Print Page | Close Window

Suppress Duplicates

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8908
Printed Date: 03 May 2024 at 11:24pm


Topic: Suppress Duplicates
Posted By: Paul46
Subject: Suppress Duplicates
Date Posted: 19 Jan 2010 at 7:23am
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - Hello,

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - I have a problem with suppress duplicates in the detailsection.

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - I have the following reportlayout:

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - -      Who -      Endtime -               Participants

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - 31 -          9.00 -                      Amsterdam file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - 31 -          9.00 -                      Amsterdam 

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - 32 -          9.00 -                      Amsterdam file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -                                                                                               file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - Total file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - All fields are in the detailsection with Suppress duplicates on.

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - In the case of the second row suppressing is good, but in the case of the third row it is not good. The third row should show all fields and count the sum in the Total row

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - Is there a way to only suppress duplicates in one eventnr. ?

file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  



Replies:
Posted By: kevlray
Date Posted: 19 Jan 2010 at 9:42am

If I understand correctly, you wish to display the record when the value of Eventnr. changes.

Two things.
First you could group by Eventnr. and put all the fields in the group footer.  This would display a 'unique' record based on Eventnr.
Second you could create a running total that evaluates when Eventnr. changes.  In this case you would have a total of 50.
 
I hope this helps.

Posted By: Theorren
Date Posted: 20 Jan 2010 at 2:08pm
This might help you as well. I had a simular question recently.
 
http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=8716 - http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=8716


-------------
- Ted

Posted By: Paul46
Date Posted: 21 Jan 2010 at 2:32am
Thanks for the answers, i'm testing them out and keep you posted.

Posted By: Paul46
Date Posted: 21 Jan 2010 at 4:44am
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - Hi again,
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - I tried your solutions but I just cannot get it how I want it.
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - Those are two examples of my lists.
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - Example 1 with “suppressed if duplicated” on all fields checked on.
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - Example2  is with this checkbox checked off.
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - In both examples the totals are correct.
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - Example1
Maandag 2 juni 2003
Wie
Starttijd
Eindtijd
Zaal
Deelnemers
3103: Test Paul
9.00
13.00
Consult
25
3109: Test Paul2
 
14.00
Parkzaal
8
3106: Test Paul
 
 
Kleine Zolder
10
 
15.00
17.00
Parkzaal
 
3109: Test Paul2
 
19.00
Kleine Zolder
8
3103: Test paul
16.00
22.00
Grote Zolder
25
Totaal
86
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - Example2
Maandag 2 juni 2003
Wie
Starttijd
Eindtijd
Zaal
Deelnemers
3103: Test Paul
9.00
13.00
Consult
25
3103: Test Paul
9.00
13.00
Consult
25
3103: Test Paul
9.00
13.00
Consult
25
3109: Test Paul2
9.00
14.00
Parkzaal
8
3109: Test Paul2
9.00
14.00
Parkzaal
8
3109: Test Paul2
9.00
14.00
Parkzaal
8
3106: Test Paul
9.00
14.00
Kleine Zolder
10
3106: Test Paul
9.00
14.00
Kleine Zolder
10
3106: Test Paul
9.00
14.00
Kleine Zolder
10
3106: Test Paul
15.00
17.00
Parkzaal
10
3106: Test Paul
15.00
17.00
Parkzaal
10
3106: Test Paul
15.00
17.00
Parkzaal
10
3109: Test Paul2
15.00
19.00
Kleine Zolder
8
3109: Test Paul2
15.00
19.00
Kleine Zolder
8
3109: Test Paul2
15.00
19.00
Kleine Zolder
8
3103: Test Paul
16.00
22.00
Grote Zolder
25
3103: Test Paul
16.00
22.00
Grote Zolder
25
Totaal
86
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -  
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml - What I want is that only exact duplicate lines are suppressed, so where all fields are exactly the same. The rest should show and count for the total. This list is for our teahouse employees so they can see how many participants are at one time in the house and how many personal  they have to call in to serve those participants.
file:///C:%5CDOCUME%7E1%5CERIC%7E1.ROO%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml -

Posted By: Paul46
Date Posted: 11 Feb 2010 at 3:16am
Bump

Posted By: kevlray
Date Posted: 11 Feb 2010 at 1:00pm
Have you tried clicking on the 'Select Distinct Records' under the Database menu item. It is designed to remove duplicate records based on what fields are displayed.
 
In your first example there is no value for the Deelnemers column or Wie column (fourth row down), but there are values in the second example.
 
This should be a fairly easy issue to fix, not sure where we are going wrong.
 
Lots of luck.

Posted By: Theorren
Date Posted: 12 Feb 2010 at 8:31am
It appears that you are suppressing individual fields. Have you tried putting the formula into the Section Expert for the suppression?
 
ie: Details Suppresion formula:
 
(starttjid =next (starttjid)
   and
   Zaal = next (Zaal))
 
(something like that in the suppression formula for the Detals in the Section Expert should work. You can add more conditions if needed to the statement.)


-------------
- Ted

Posted By: DBlank
Date Posted: 12 Feb 2010 at 9:02am

Do not confuse supressing duplicate rows with excluding them from your totals. Suppressed data still exists and is still going to be included in totals.

You have to either exclude it fromt he report (e.g. Kevlray's suggestion of using Select Distinct records) or exclude it from your summarization via conditionally Running Totals or Variable formulas.

Posted By: Theorren
Date Posted: 12 Feb 2010 at 10:27am

Thanks for pointing that out DBlank, I didn't think of it when I posted.



-------------
- Ted


Print Page | Close Window