Groups in a report

deepblue

Hello,

I need to group lines in a report by Item No.
I have two DataItem, the first one is the header and the other represents the lines. The primary key in the second dataitem is "Job No.,Line No.". I want to group lines by Item No and to display it only one time befor its relatives lines?

Can you help me?

Thank you,

Balello

You need an ordering key that contains Item No. as first field after you "linking to header" fields. Eg. Sales Line links to Sales Header by Document Type and Document No., so you need the key: Document Type, Document No., No. to filter with the same No. code.

kine

yes, as Bello wrote... and after that, you can use the group header to show the Item and GroupTotalFields for setting the Item No. as field for gouping..