1543453 - Crystal Report based on Universe showing Duplicate Records in Crystal Reports Designer

Crystal Report based on Universe showing Duplicate Records in Crystal Reports Designer

• Business Objects Enterprise 3.1
• Crystal Reports 2008

1. Open the Report in Crystal Report Designer
2. From Standard Toolbar choose click on "Database" tab and launch "Database Expert"
3. Right click on Universe Query
4. Select "Edit Command"
5. Click on "Properties" tab this will launch "Query Options"
6. Set "Your Query may return duplicate rows. Do you want to retrieve duplicate rows in the final result set? " option to "No"

Duplicate rows, universe, Crystal Report , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem