Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Be insatiably curious. Ask 'why' a lot
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

08
January

How Do I Remove Duplicate Records in Crystal Reports?

I have had a number of clients with the problem of their dataset returning duplicate records in Crystal Reports.

Usually when duplicate records are being returned in Crystal Reports, this is mainly due to the relationships defined between the tables and/or the views of the report.

Solution

The first issue would be to look at the relationships of the tables and/or views used within the report.


Crystal Reports has a feature that removes duplicate records from the report.

To remove duplicate records:

From the Database menu, select the Select Distinct Records option



If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


1

sathish

05
April
Am unable to check the select distinct records because its been disabled. Please suggest me how to enable it and check it
2

Julia

05
April
Hi Sathish

What is the underlying data source for the report?

Are you using tables, stored procedures or and SQL command?

MAKE A COMMENT

Name *

Email Address *

Comment *