Symptom
- Empty List of Values.
- Dynamic parameter doesn't show any List of Values in Crystal Reports Viewer.
- Rather than a drop down list containing a List of Values, the dynamic parameter shows as an empty text box in Crystal Reports Viewer.
Environment
- SAP Crystal Reports Viewer 2013
- SAP Crystal Reports Viewer 2016
- SAP Crystal Reports Viewer 2020
Reproducing the Issue
- In Crystal Reports, create a report off any data source.
- Add a dynamic parameter to the report.
- Save the report to the SAP BusinessObjects Repository.
- In Crystal Reports Viewer, open the report from the SAP BusinessObjects Repository and refresh it.
Notice the Dynamic Parameter shows no list of values.
Cause
- This is expected behavior, because when a report is save to the SAP BusinessObjects Repository, it creates a Business View, and Business Views are not supported in Crystal Reports Viewer. This is why the dynamic parameter shows no values.
Resolution
-
To workaround this Crystal Reports Viewer limitation, open the report in Crystal Reports, and set the parameter with a static list of values.
- To be able to refresh the report, and view a dynamic List of Values for the parameter, view the report in:
- Crystal Reports; or
- SAP BI LaunchPad.
Keywords
CR Server, Infoview, BV , KBA , BI-RA-CRV , SAP Crystal Reports Viewer , Problem
Product
SAP Crystal Reports viewer 2013 ; SAP Crystal Reports viewer 2016 ; SAP Crystal Reports viewer 2020