Duplicate record identification & Formatting the dup.records

[gurlfob]

Hi, I am trying to format a report as below:

Type UOM Price
-----------------------------------------
A Lot A 50.00
B Lot A as above in Lot A
C Lot A as above in Lot A
D Lot B 75.00
E Lot B as above in Lot B
F Unit 45.00
G Lot A as above in Lot A
H Unit 25.00
I Unit 80.00
J Lot B as above in Lot B
If UOM is "Unit", display the price as it is. If UOM is a "Lot Type"...I have to disply the price for first instance and display "as above..." in the other instances.
I'd appreciate if anyone could help me. Thanks.

 

[paulmarr]

Parnini,

One way would be to create a formula with a global numbervar (variable)for each UOM Type - and increment the counter (counter:=counter+1) in the first instance - so when counter > 0 print "as above"

Hope this helps

paulmarr