how to group by record in NAV

jaiverma2k2

Hi all,

i've one table havig column below -
Item Code
Lot No
MRP
Location

There are multiple MRP against multiple LOT No. now i want to group the record on screen with Item & MRP
e.g.
1001 LOT1 200 XYZ
1001 LOT2 200 XYZ
1001 LOT3 300 XYZ

Te ouput required
1001 200
1001 300

please help me

Regards,
Jai Verma

kine

You can use the standard way: using temp table into which you can add record for each combination you need (if the record do not exists already).

Or if you are using report, just use the correct key to sort the records and use GroupFooter/GoupHeader to print the values.