Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Reports are duplicating data Post Reply Post New Topic
Author Message
Snafu
Newbie
Newbie


Joined: 10 Nov 2008
Location: Canada
Online Status: Offline
Posts: 1
Quote Snafu Replybullet Topic: Reports are duplicating data
    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 
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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

IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.