Grouping with more than one field

sunnyk

Hi Experts,

i have some confusion in grouping a report. Suppose i need to group Item ledger Entry first on Item No than on Location code. i made a key in table with these two fields nad defined the GroupTotalFields property as Item No, Location Code.
But i want the result to be grouped as
Item No XXXX
Location Code ABBCD
Details......................................................
Location Code ABBEF
...............................................................

I tried but to no Success!!

Can someone please tell me how to do the grouping with two dataitems.

Thanx in Advance..

ritesh.singh

Create this report using the report wizard and then analyse this report.

satraja2004

Hi,

u can use the SETFILTER command on the ONPREDATAITEM trigger of that data item.