onfirstrecord

[Former Member]

Dear All,

I have a problem,

i have so many purchase order number, take one purchase order number i have so many items (1.000,1.101,2.000,2.101) like this. OK

I have one indicator column ok..

for first item(1.000) i want to put 'H' in indicator column and remaining items i want to put 'I'

all fields i am put in details section. i want to export to excel later.i am using CR XI R2

plz help me, thanks in advance.

Purchase order No Item NO Indicator

1001 1.000 H

1001 1.101 I

1001 2.000 I

1001 2.101 I

regards,

raghu.

[Former Member · Accepted solution]

Make sure the report is grouped or sorted on PO# and Item#.

Use the following formula for your indicator.

IF OnFirstRecord OR PONO <> Previous(PONO) THEN
    "H"
ELSE
    "I"

[Former Member]

Yes, I am group by PONO..thank you its working..