Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: how to remove the duplicate Post Reply Post New Topic
Author Message
android
Newbie
Newbie


Joined: 20 Jan 2011
Location: Philippines
Online Status: Offline
Posts: 3
Quote android Replybullet Topic: how to remove the duplicate
     Posted: 20 Jan 2011 at 8:26pm
Hi,

How do i filter the two tables in order show only one entry? should be:
doc.inc doc.do
1        1
2        2
3        3

instead of:


doc.inv     doc.do
1     1
1     1
1     1
1     1
2     2
2     2
2     2
2     2
3     3
3     3
3     3
3     3
3     3



thanks
IP IP Logged
JohnT
Groupie
Groupie
Avatar

Joined: 20 Jan 2008
Online Status: Offline
Posts: 92
Quote JohnT Replybullet Posted: 21 Jan 2011 at 5:15am
You could try the select distinct records options.  Go to File, Report Options and check the box for Select Distinct Records.
IP IP Logged
android
Newbie
Newbie


Joined: 20 Jan 2011
Location: Philippines
Online Status: Offline
Posts: 3
Quote android Replybullet Posted: 22 Jan 2011 at 6:51pm
thank you! it worked.
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