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 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

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 no workaround to set a default value for a dynamic parameter in Crystal Reports.
             
  • This product enhancement have already been posted on SAP Idea Place under D3586 
           
    Note: Product enhancement posted on SAP Idea Place does not guarentee the requested feature will be added to any future version of Crystal Reports, but the most voted product enhancements submitted are reviewed.

Keywords

CR, Dynamic param, Dynamic LOV default value , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016