Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Identify Duplicate order numbers Post Reply Post New Topic
<< Prev  Page  of 2
Author Message
Robotacha
Groupie
Groupie
Avatar

Joined: 11 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 97
Quote Robotacha Replybullet Posted: 14 Jul 2011 at 3:49am
AHHHH,
 
the supression on the CUSTOMER GROUP dont work correctly.
 
If for example:
 
CUSTOMER A
on/123456
count=1
on/234569
count=2
on/246810
count=1
CUSTOMER B
CUSTOMER C
 
I supressed the CUSTOMER GROUP baesd on the count <=1
 
whilst it stills shows the duplicated invoice, is is now removing the customers name. (obviously because he has had none duplicated invoices aswell)
 
How can i get round this?
Regards,

Michael Jones
IP IP Logged
Robotacha
Groupie
Groupie
Avatar

Joined: 11 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 97
Quote Robotacha Replybullet Posted: 14 Jul 2011 at 4:04am
I really should put some effort in before posting eh!! lol
 

Sorted this:
 
GROUP SORT - Sort all ORDERNUMBER GROUP  by COUNT (descending)
 
this put the 2 or above counts first
 
 
the group suppression then worked at is should.
 
 
thanks!
Regards,

Michael Jones
IP IP Logged
<< Prev  Page  of 2
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