Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: suppressing repeated information Post Reply Post New Topic
Author Message
figgy
Newbie
Newbie


Joined: 19 Nov 2013
Online Status: Offline
Posts: 23
Quote figgy Replybullet Topic: suppressing repeated information
    Posted: 24 Oct 2014 at 3:49am
I have a report that prints out our quotes all the information is listed in the detail section of crystal.  Right now if i print a quote it looks like this:
Line   description        qty       price
1          xyz                  1          1.00
If I am printing a report that has multiple quantities it looks likes this
Line   description        qty       price
1          xyz                  1          1.00
1          xyz                  2          2.00   etc...
I want it to show the line, description only once so it looks like this:
Line   description        qty       price
1          xyz                  1          1.00
                                   2          2.00  
How would I go about doing this?  I've tried moving some of the tables to the  header but then it looks like this:
Line   description        qty       price
1          xyz                 
                                   1          1.00
                                   2          2.00  
Any help would be appreciated!

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 24 Oct 2014 at 4:07am
keep the fields in the detail section
right click on any of the items you want suppressed
select format field
select common tab
check 'Suppress if Duplicated' as true
select OK


Edited by DBlank - 24 Oct 2014 at 4:08am
IP IP Logged
figgy
Newbie
Newbie


Joined: 19 Nov 2013
Online Status: Offline
Posts: 23
Quote figgy Replybullet Posted: 24 Oct 2014 at 4:09am
IP IP Logged
figgy
Newbie
Newbie


Joined: 19 Nov 2013
Online Status: Offline
Posts: 23
Quote figgy Replybullet Posted: 24 Oct 2014 at 4:12am
I use crystal reports once in a blue moon, when my boss wants something done, then its always "I need it done quickly".  Posted the question then thought about it and realized that I could suppress duplicates.  Thank you for your quick reply!Smile
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.