on 06-18-2015 9:08 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.