- Report created in Crystal Reports 8.5.x or older.
- SQL Query was modified to create UNION ALL.
- Running the report in CR 2011 +, the second part of the Union is ignored.
- Crystal Reports 9.x and higher
Reproducing the Issue
- Crystal Reports 8.5 allowed edit of the SQL statement.
- Modify the SQL statement.
- Run the report in CR 9 or later.
- Edit of SQL statements in the Crystal Reports designer was eliminated in CR 9.x and later.
- Copy the SQL from the old report.
- Open the report in a new version of Crystal Reports and go to Show SQL > Reset.
- Under Database Option go to Set Datasource Location and from the panel at the bottom create a connection to the database.
- Expand the connection name and Highlight Add Command.
- Highlight the Table Name on the Panel on the top panel and Click Update.
- Paste the SQL query you copied in step 1 and click on OK.
- The Command Window also has an option on the right to create parameters.
- If the report will use parameters, create the parameters in the Command Editor in order for them to be "visible" to the command.
- Once the parameter has been created in the Command Editor, it can be edited in the Field Explorer to change or manage the properties.
- Example:, make the parameter with a dynamic prompt.
CR connect query union db , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem
Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 9.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2