Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Records are getting repeated Post Reply Post New Topic
Author Message
irfanshirur
Newbie
Newbie
Avatar

Joined: 08 Jan 2009
Location: India
Online Status: Offline
Posts: 1
Quote irfanshirur Replybullet Topic: Records are getting repeated
     Posted: 08 Jan 2009 at 9:31pm
Hi

I am Facing an issue with Crystal report details section.

i have two data table

Table1 - Which contains the Master data
Table2 - Which contains the some of the columns of the Table1

Tables 2 data I am binding in the details section of the report so there
if 2 records are there  in datatable i am getting 4 records(Same 2 records repeated again)

Please Can any one help me out to resolve this issue.

Thanks and Regards
Mohammed Irfan


Edited by irfanshirur - 08 Jan 2009 at 9:39pm
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Jan 2009 at 7:34am

You need to see how your tables are joined and try to address it there. If you are joining your tables on a field in your "Master data" table that has more than 1 row for that that field, row 1 will join to each matching record in the other table and then row2 repeat the process giving you "multiples" the way you describe.

IP IP Logged
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