SAP Knowledge Base Article - Public

1570941 - How to add a default value to a dynamic parameter in Crystal Reports?

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

  1. In Crystal Reports, create a report off any data source.
       
  2. Create a new parameter, and for the option "List of Values", select "Dynamic"
       
  3. 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.
         
  4. 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