Groups in a report

deepbluedeepblue Member Posts: 152

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,


  • BalelloBalello Member Posts: 61
    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.
    I don't envy anybody who caught up his aim. I travel gladly.
  • kinekine Member Posts: 12,562
    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..
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.