Print Page | Close Window

suppressing repeated information

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21131
Printed Date: 19 May 2024 at 12:37am


Topic: suppressing repeated information
Posted By: figgy
Subject: suppressing repeated information
Date 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!




Replies:
Posted By: DBlank
Date 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


Posted By: figgy
Date Posted: 24 Oct 2014 at 4:09am


Posted By: figgy
Date 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



Print Page | Close Window