Print Page | Close Window

Reports are duplicating data

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4755
Printed Date: 05 May 2024 at 10:40pm


Topic: Reports are duplicating data
Posted By: Snafu
Subject: Reports are duplicating data
Date Posted: 10 Nov 2008 at 3:22am
Hey All
 
I'm attempting to troubleshoot a problem where having with Crystal Reports XI. It's seems that Crystal Reports is duplicating the data that it pulls out of our time entry system, so our customers are getting billed for double the time. The interesting thing is that up until last week it all worked fine, and I'm sure that nothing has changed on the server.
 
I'm new to Crystal Reports and not sure what I should be looking for, but I can tell you that the data for this report is pulled from a Notes DB using the NotesSQL driver.
 
If could tell me where to start my investigation, it would be much appreiated.
 
Thanks 


Replies:
Posted By: rahulwalawalkar
Date Posted: 10 Nov 2008 at 4:39am

Hi

Do you have snapshot of last report which was genereated ,Check to see what has changed,since then...

I would start with Data i.e check for Joins on tables.....

Check for filters in your report. record selection ,group selection formulas.....

Cheers

Rahul

Posted By: hilfy
Date Posted: 11 Nov 2008 at 3:32pm
One other thing you can do is in the report itself go to the Database menu and turn on "Perform Grouping on Server" and "Select Distinct Records".
 
This helps in most, but not all, cases of duplicate data.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window