Symptom
- Two different parameter prompt page displays.
- Two separate prompt screen shows when refreshing a report in Crystal Reports, or in Crystal Reports for Enterprise.
- How to only display one prompt screen that list all of the parameters, instead of 2 different prompt window?
Environment
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports for Enterprise 4.0
- SAP Crystal Reports for Enterprise 4.1
- SAP Crystal Reports for Enterprise 4.2
Reproducing the Issue
- In Crystal Reports, create a report off any data source.
- Add a Command Object to the report with one parameter. For example:, the SQL Query in the Command Object is like:
Select Name, City, Region, Country
From Customer
Where Country = '{?Country Parameter}'
- In the report, create a second parameter, and set the parameter to be dynamic based on a database field from the Command Object.
For example: Create a dynamic parameter on the database field: City
- Add the second parameter to the report design.
- When refreshing the report, it first display a prompt page for the parameter created in the Command Object.
- After entering values for the parameters, it then display a second prompt page with parameter created on the report. Why can't all the parameters prompt in one window, instead of 2 separarte prompt screen?
Cause
- This is expected behavior when a dynamic parameter is based on a Command Object that includes parameters.
- In more details: The reason it displays 2 different prompt screens for the parameters, it's because the parameter created on the report is set to be dynamic, and it is based on a database field coming from the Command Object, which also includes a parameter. In order to retreive a dynamic list of values, the SQL Query in the Command Object needs to be executed first, and therefore needs to first prompt for the Command Object parameter, then retreive the dynamic List of Values, and display it in the second prompt window. In brief, it is normal behavior.
Resolution
- If possible, remove the parameter(s) from the Command Objects.
- If it is not possilble, then if you are using Crystal Reports, create in the Business View Manager, a List of Values based on a Table or a Command Object without parameter, then associate the List of Values created in the Business View Manager, to the parameter on the report.
Keywords
parameter window. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016