Symptom
- How to set a default value for a dynamic parameter?
- How to add a default value to a dynamic List of Values (LOV)?
- How to add a default value to a parameter associated with a dynamic List of Values in Crystal Reports?
- Default value option for a dynamic parameter is missing, how to add a default value to a parameter in Crystal Reports?
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Reproducing the Issue
- In Crystal Reports, create a report off any data source.
- Create a new parameter, and for the option "List of Values", select "Dynamic"
- Under "Choose a Data Source", select "New", then associate it with a with a database field to obtain a dynamic list of values, or select "Existing", and select an existing dynamic List of Values.
- Under "Value Options", notice there is no option to set a default value for the parameter, but when the parameter is static the option is available to set a default value.
Cause
- By design, there is no option in Crystal Reports to set a default value for a dynamic parameter.
Resolution
- There is unfortunately no workaround to set a default value for a dynamic parameter in Crystal Reports.
Keywords
CR, Dynamic param, Dynamic LOV default value , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020