Skip to Content
0
Former Member
Feb 26, 2014 at 02:00 PM

Sum and Suppress Duplicate Records

541 Views

I have Crystal Reports XI, and I have a report with the following fields:

DESCRIPTION OPTION_QTY LONG_DESC

With a sample of data as follows:

SightGlass 1 Sight Glass-100

SightGlass 1 Sight Glass-200

SightGlass 1 Sight Glass-300

HoseAdapters 1 610-Adapter

HoseAdapters 1 610-Adapter

HoseAdapters 1 610-Adapter

Manholes 2 VR-Manhole

Manholes 2 VR-Manhole

Manholes 2 VTS-Manhole

Manholes 2 VTS-Manhole

I have set up a Running Total Field called QtyTot that summarizes the OPTION_QTY field... Evaluates For Each Record... and Resets On change of LONG_DESC field.

I'm trying to display this report so it will suppress the duplicate records, but show the summarized quantities of those duplicate records also. If I use suppression on the DESCRIPTION field, it cleanly eliminates the subsequent duplication. However, when I try to use the same suppression on the LONG_DESC field, it also eliminates the subsequent records... which include the true QtyTot value!

I want the report to display like this:

DESCRIPTION QtyTot LONG_DESC

SightGlass 1 Sight Glass-100

1 Sight Glass-200

1 Sight Glass-300

HoseAdapters 3 610-Adapter

Manholes 4 VR-Manhole

4 VTS-Manhole

but it is displaying like this instead:

DESCRIPTION QtyTot LONG_DESC

SightGlass 1 Sight Glass-100

1 Sight Glass-200

1 Sight Glass-300

HoseAdapters 1 610-Adapter

Manholes 2 VR-Manhole

2 VTS-Manhole


I've tried various combinations/formulas of the suppression settings, but cannot figure out I can get the appropriate DESCRIPTION heading, QtyTot value, and LONG_DESC to display. Can anyone help?