Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Suppress If Duplicated Option in Crystal Post Reply Post New Topic
Author Message
a4chan
Newbie
Newbie
Avatar

Joined: 07 Aug 2010
Location: United States
Online Status: Offline
Posts: 21
Quote a4chan Replybullet Topic: Suppress If Duplicated Option in Crystal
    Posted: 12 Aug 2010 at 12:10pm
Hi,
 
 I want my data to be supressed based on particular department ID.My data looks like this :
 
Dept ID Emp Name Location
2000 John Dallas
2000 John Dallas
2001 John Dallas
2001 John Houston
2002 John Houston
2002 John Houston
 
Output should look like this :
Dept ID Emp Name Location
2000 John Dallas
2001 John Dallas
2001 John Houston
2002 John Houston
 
If I use suppress if duplicated check box in the format field when I right click on an object,it suppress all the duplicated data irrespective of the department ID.Also I don't want any blank spaces to be on the report.The output should look like the one I gave an example above.Can anyone please let me know how to resolve this issue ?
 
Thanks


Edited by a4chan - 12 Aug 2010 at 12:10pm
a4chan
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 13 Aug 2010 at 3:33am
well if the built in functionality is not working, I would try:
in the section expert for the section desired (probably detail from the looks of it) in the suppress x-1 button:
 
Shared stringvar nameYear;
 
if {table.year}+{table.name} <> nameYear then (
  nameYear := {table.year}+{table.name};
  false;
)
else
  true;
 
as a caveat, this will suppress the display, but if you are using an aggregate, like SUM(), the suppressed values will be in the total...you would need to set a Running Total (which is DBlank's forte) or create one using global/shared variables (which is what I would do)
 
HTH
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.016 seconds.