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
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"