Parameters and filters work very close together. Adding parameters and creating a filter in a report allows you to create a single report that you can modify whenever the reporting requirements change.
To add a parameter to the report:
- Right-click on the Parameter Fields section and click New in the Field Explorer view. The Create New Parameter screen opens.
- Enter the information relevant to your new parameter. You should provide at least the following values:
- Name - Parameter name. When a parameter field name appears in the report, the program puts a question mark at the beginning of the name to identify it is a parameter field. For example, if you name a parameter field "My Parameter", the name appears in the field list in the Formula Workshop as "?My Parameter".
- Type - Data type of the parameter. If this parameter is used to filter based on a database field, the parameter type should match the database data type.
- List of Values - Set to Static. Ungerboeck only supports Static Crystal parameters.
- Prompt Text - Text that displays to users when asking for the parameter value.
- Click OK.
Active Parameters and Special Lookup Fields
Ungerboeck passes a specific set of parameters based on the screen the report is called from. These parameters are managed on the Report List Master screen. These parameters are identified by using the "@" character in front of the parameter name, i.e. @Organization, @Event, @Order, etc.
To learn more about which parameters are available on each screen, see Supported Report Parameters. To learn more about Special Lookup fields, see Crystal Reports Special Lookup Fields.
Comments
6 comments
Yes, this works great if you aren't using Ungerboeck tables, but I think it should be mentioned that Parameters are handled differently, specifically the Active Parameters. I learned the hard way about this and still not sure I have all the information I need.
0 upvotes
Thank you for your comment Lori. There are additional articles in the knowledge base that cover the topics of Active Parameters and Special Lookup fields and as you mention, it is a good idea to reference these articles in this one. I have added three links to these articles to complement the information shown here.
Thanks again for helping us build a better Knowledge Base.
0 upvotes
Dynamic prompts now work? are they only applicable/supported from version xx.xx onwards? Previous attempts to use Dynamic prompts within UB crystal reports have not worked.
1 upvotes
I am trying to use a dynamic prompt in my report without any luck so far. Based on Jason's reply can I assume that this functionality is still not available in Ungerboeck (I am hoping that given the latest post on this is 4 years old, that things have changed).
Your help is much appreciated! Regards, Nikki
0 upvotes
Hello Nikki,
Ungerboeck offers several ways to pass parameters from the application to a Crystal Report. Whether it is using static or dynamic parameters set up on the report itself or using Ungerboeck's Active Parameters and Special Lookup fields, the reporting servers cover a wide set of options.
While all these options have been available for several years, I believe that there was a short period where v20.x windows were not operating correctly when using some specific dynamic parameter configurations, nevertheless, this was addressed in the next immediate release.
If you still have questions specific to the report you are building after reviewing the articles shared here, please contact your Ungerboeck's Client Care department and we will be happy to help.
Thank you.
0 upvotes
Hi Nikki, it may help if you can clarify whether you are referring to what Crystal call dynamic parameters or what USI call dynamic parameters?
I'm 99% sure v19 and v20 are still yet to support Crystal's dynamic parameters (I just ran a quick test).
0 upvotes
Please sign in to leave a comment.