How to display the First row on each Details Section?

[Former Member]

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

[abhilash_kumar · Accepted solution]

Hi Reshma,

Place all fields on Group Header 2 and suppress the details section.

-Abhilash

[Former Member · Accepted solution]

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

[Former Member]

Abhilash please help with the above..

I am new to Crystal Reports and stuck in this issue

[Former Member]

Hi Reshma,

You can use SUM on weight and place it in Group Footer.

If you are selecting the group number at run time then use Running Total.

Thanks,

Nilesh