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.