Symptom
Not able to get the same number of Rows in Crystal Reports as when the Query is executed from the Bex Analyzer.
Environment
- Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
Reproducing the Issue
- Launch Crystal Reports.
- Go to File >> New >> Blank Report
- In the Database Window click on Create New Connection
- Select the Data Source : SAP BW MDX Query
- Select the SAP System
- Enter the details for the SAP System
- Click on Finish
- Now select the BEx Query from the Connection and create the report
- You will not be able to see the Empty Data from the BEx Query.
Cause
- The Extended Logon Parameter : "Show Empty Data" is not checked
Resolution
- Launch Crystal Reports 2011
- Go to File >> New >> Blank Report
- In the Database Window click on Create New Connection
- Select the Data Source : SAP BW MDX Query
- Select the SAP System
- Enter the details for the SAP System
- Click on Next
- Now the Extended Logon Parameters window will appear
- Check the Show Empty Data option.
- Click on Finish.
- Now select the BEx Query from the Connection and create the report
- You will be able to see the Empty Data from the BEx Query.
Keywords
CR2011, empty data, less number of rows, query , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013