Suppress duplicate Detail Sections 1

[Buckaroo8]

Hi All,
I have a set of fields in the Details section of my report (CR8.5) and it is displaying exact duplicate information twice.
Example:
---*--------------------------------------------------
D * Field1 Field 2 Field3
*
---*--------------------------------------------------
D * Field1 Field 2 Field3
*
---*--------------------------------------------------

So how can I suppress the section if it is completed duplicated? Is there something like "RepeatedInGroupHeader" type function or something, but applicable to the Details section?

Thanks for All help!

 

[kchaudhry]

You can try this:

Database > Check "Select Distinct Records"

This will remove the true duplicates.

Kchaudhry

 

[Buckaroo8]

Is this formula placed in the Suppression condition (of the Details Section) or Record selection for the report?

Thanks!

 

[kchaudhry]

By selecting this option you are not suppressing the details section. When your report is generated only distinct records will be shown. Suppressing the records means that they are still there but not visible(can slow down your report). On the other hand this option will only read those records which meet your criteria.

Kchaudhry

 

[Buckaroo8]

Great!
Sorry I misread as a formula, my bad...

Thanks a lot for your help!

 

[kchaudhry]

I am glad to help

Kchaudhry