3596459 - Optional parameter becomes mandatory in Crystal Reports

• Optional parameters are now mandatory.
• After migrating reports from SAP BusinessObjects BI 4.2, to 4.3, the Optional prompts are now Mandatory.
• Report parameters are created in a Command Object, and set to optional in Crystal Reports.

• SAP Crystal Reports 2020 - Support Pack 04 - Patch 700
• SAP Business Intelligence Business Intelligence Platform 4.3 - Support Pack 03 - Patch 700

1. In Crystal Reports, create a report based on any data sources.
2. Create Command Object, and enter your own SQL Query, like:
   
        SELECT < Database Field 1>, <Database Field 2 >
        FROM < Table >
   
   
3. Add a parameter in the Command Object, and it to your custom SQL Query in the WHERE clause like:
   
        SELECT < Database Field 1>, <Database Field 2 >
        FROM < Table >
        WHERE  < Database Field 1 > = < Parameter 1 >
     
4. In the report, edit the Parameter, and set it to Dynamic, and select a dynamic list of values.
5. Change the parameter option "Optional Prompt", and set it to: True
6. Save the report to the SAP BusinessObjects BI platform.
7. Close the report.
8. In Crystal Reports, re-open the report.
9. When refreshing the report, notice the Parameter is now Mandatory
10. Edit the parameter, and notice the Optional Prompt option is now set to: False.

• Product defect.

• The issue resolved in the following product update and above:
  
  
  • Crystal Reports 2020 - Support Pack 04 - Patch 11
  • Crystal Reports 2025

CR, prompts, param , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem