Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Suppress Duplicates Post Reply Post New Topic
Author Message
Paul46
Newbie
Newbie


Joined: 19 Feb 2008
Online Status: Offline
Posts: 22
Quote Paul46 Replybullet Topic: Suppress Duplicates
    Posted: 19 Jan 2010 at 7:23am

Hello,

 

I have a problem with suppress duplicates in the detailsection.

I have the following reportlayout:

 

 

Eventnr.     Who          Starttime     Endtime              Location              Participants

 

31                    Paul         9.00                 12.00                     Amsterdam                       25

31                    Paul         9.00                 12.00                     Amsterdam                       25

32                    Paul         9.00                 12.00                     Amsterdam                       25

                                                                                              Total                                                                                                                                        75

 

 

All fields are in the detailsection with Suppress duplicates on.

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

Is there a way to only suppress duplicates in one eventnr. ?

 



Edited by Paul46 - 19 Jan 2010 at 7:24am
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
Theorren
Newbie
Newbie
Avatar

Joined: 22 Dec 2009
Location: United States
Online Status: Offline
Posts: 10
Quote Theorren Replybullet Posted: 20 Jan 2010 at 2:08pm
This might help you as well. I had a simular question recently.
 
- Ted
IP IP Logged
Paul46
Newbie
Newbie


Joined: 19 Feb 2008
Online Status: Offline
Posts: 22
Quote Paul46 Replybullet Posted: 21 Jan 2010 at 2:32am
Thanks for the answers, i'm testing them out and keep you posted.
IP IP Logged
Paul46
Newbie
Newbie


Joined: 19 Feb 2008
Online Status: Offline
Posts: 22
Quote Paul46 Replybullet Posted: 21 Jan 2010 at 4:44am
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
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



Edited by Paul46 - 21 Jan 2010 at 4:45am
IP IP Logged
Paul46
Newbie
Newbie


Joined: 19 Feb 2008
Online Status: Offline
Posts: 22
Quote Paul46 Replybullet Posted: 11 Feb 2010 at 3:16am
Bump
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
Theorren
Newbie
Newbie
Avatar

Joined: 22 Dec 2009
Location: United States
Online Status: Offline
Posts: 10
Quote Theorren Replybullet 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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
Theorren
Newbie
Newbie
Avatar

Joined: 22 Dec 2009
Location: United States
Online Status: Offline
Posts: 10
Quote Theorren Replybullet Posted: 12 Feb 2010 at 10:27am

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

- Ted
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.029 seconds.