Skip to Content
avatar image
Former Member

How to display the First row on each Details Section?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 07, 2015 at 04:49 AM

    Hi Reshma,

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

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Jan 07, 2015 at 05:19 AM

    Abhilash please help with the above..

    I am new to Crystal Reports and stuck in this issue

    Add comment
    10|10000 characters needed characters exceeded

    • 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