Issue Displaying Relevant Data On a Report

[Former Member]

I'm very new to Crystal Reports so that might be why this is such a novice question but while creating a report I am displaying more records than I actually want to.  Currently this is what is being displayed:

Store #      DCSCode       Description1         Description2             Attr          Size               OH QTY

   0            ACCBOW       FB113                 PINCH CLIP BOW     49                                     0

   0            ACCBOW       FB113                 PINCH CLIP BOW     57                                    (1)

   0            ACCBOW       FB113                 PINCH CLIP BOW     57                                     0

What I want to display would combine the last two records as one.

I think what is happening is that because there is are multiple OH QTYs in the database for the same item it is pulling each of those records with its OH QTY.

Is there a way to combine those records and how would you go about doing so?

Thank you for the assistance.

[abhilash_kumar · Accepted solution]

Hi Corey,

1) Create a formula with that concatenates all fields except the Qty field.

{Store} & {Description} & . . & . . & so on..

2) Insert a group on this formula field

3)Move all fields from the details to the group footer

4) Suppress the details section

5) For the Qty field you may insert a summary with the sum function as sum or max depending on how you want the qty to appear as

-Abhilash

[Former Member · Accepted solution]

Oddly enough I was looking at the report last night and I did just that.  It worked perfectly.

Thank you so much for the reply