on 01-07-2015 4:43 AM
I have a crystal report whose data structure is somewhat like
TO NUMBER | STOP NUMBER | PO# | SO# |
---|---|---|---|
100000 | 1 | PO1 | SO1 |
100000 | 2 | PO2 | SO2 |
100000 | 2 | PO3 | SO3 |
100000 | 2 | PO4 | SO4 |
100000 | 2 | PO5 | SO5 |
Now the Details section shows po and so data per stop number in each page
like
Group on TO NUMBer
--------------------------------
Data
Group on Stop ID
--------------------------------
group on stop number
---------------------------------
Data
--------------------------------
Details
-------------------------------
So now in 1st page ,1st stop data is shown
2nd page , 2nd stop details is shown.
As you can see for stop number 2 there are 4 details. I need that it shows only the first record per stop and suppress the other records.
Please help.
Thanks in advance
Hi Reshma,
Place all fields on Group Header 2 and suppress the details section.
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Abilash , It worked like charm. I have another Query.. There are some weight associated to each PO and SO Combination for each stop
like
Stop NUmber - 2
PO2 SO2 20KG
PO3 SO3 40 KG
As you know , we are displaying only the first record now..the Kgs Total is showing as 20 Kg ONLY.
But I need to display the data like this:
PO2 SO2 60kgS
Please help on how to achieve that?
Kind Regards,
Reshma
Abhilash please help with the above..
I am new to Crystal Reports and stuck in this issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.