Elimanating Duplicates in report 1

[gscheepers]

Hi,

I'm trying to remove all duplicates that's displayed from an field.

If a field's data is displayed more than once, I would like it to be suppressed.

Any help would be grateful!

Thanks, Gerhard Scheepers
BA - LETEC

 

[Ngolem]

Are you talking about successive detail lines??? There are many ways of eliminating "duplicate" values...you have to describe your situation in more detail.

It can be as simple as placing thi formula in the conditional suppress of the field.

WhilePrintingRecords;
previous({Table.field}) = {Table.field};


or more complicated depending on where the offending fields are. Jim Broadbent

 

[gscheepers]

Jim,

Currently I'm trying to display ONLY duplicate postcodes in the database. The information is grouped by postcode. What I do need to see is all the duplicates with the same postcode to remove them afterwards.

I hope this helps,

Thanks, Gerhard Scheepers
BA - LETEC

 

[synapsevampire]

Group on the postcode, then suppress your detail and group footer.

Insert a summary field that counts the postcodes at the group footer level.

Now insert the count into the suppress no drill down formula of the group footer:

Count ({Testdate.postcode}, {Testdate.postcode}) < 2

This will only show records with 2 or more.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

Oooops...this:

&quot;Group on the postcode, then suppress your detail and group footer.&quot;

Should have read:

&quot;Group on the postcode, then suppress your detail and group HEADER.&quot;

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Guest_imported]

Problem in eliminating duplicates in detail line. Novice user; V. 8.5.0.217
Simple report with 2 tables. Desire to eiminate duplicate detail of 2 columns. Have checked Suppress if Duplicate under Common of Format Field / did not eliminate duplicate printing; Saw above code in this thread (whileprintingrecords etc) and added that to report but still no success in eliminating duplicate data. Built another simple report and simply used Suppress if Duplicate under Common of Format Field and report appeared as desired with duplicate data removed. Any ideas on why the 2 methods of eliminating duplicate consecutive detail lines is not working?
Thanks a bunch!!! Dorisciv

 

[dgillz]

Suppress if duplicate is for a single field, not the entire record.

Use SV's formula above, but reverse the arrow direction, to exclude duplicates from the report altogether, no supression required. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[Guest_imported]

Thanks for your quick response.
However, I am looking to remove the repeated data in the detail field of the report. To clarify, I'd like to see

(Header Line) Title of Item Quantity
Detail Line The Quick Brown Fox 800
&quot; No Title 50
&quot; 25
&quot; All Men with Beards 6
&quot; All Children of Single Parents 99

Instead of:
(Header Line) Title of Item Quantity
Detail Line The Quick Brown Fox 800
&quot; No Title 50
&quot; No Title 25
&quot; All Men with Beards 6
&quot; All Children of Single Parents 99
Thanks, Dorisciv

 

[dgillz]

Right click the {TitleofItem} field, format, and select suppress if duplicated. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com