Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue Displaying Relevant Data On a Report

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.

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question