Grouping 3 fields in Item Ledger Entry

ayashi

Hi Guys,

I need to group 3 fields in item ledger entry : location, item, posting date.

I already use 2 data item :
- Location
- Item Ledger Entry (group by item no.)

This only result in group by location and then item, but not the posting date.

I don't know other data item I have to use in order to create this report,
can anyone point me to the right direction ?

Thx

Alex_Chow

Did you create 2 GroupFooter sections on your report under the Item Ledger Entry?

ayashi

hi deadlizard,

nope, I only create 1 group footer, but it seems that this group footer always shown twice, if I create 2 group footer, it will shown 4 times.

Sorry, I didn't mention before that for second indented data item which is item ledger entry, I use group by item and posting date (cause location already group by first data item).

What should I do to disable the group footer shown twice ?
Cause the result in group footer already shown the data just like I want it to, the problem is, this section always printed twice.

Thx

Chandan_kansal

You should make a key including all the three fields in ILE and then make ur report using Riport Wizard...I think this will help you...