Group Total Fields in Reports

Madhan
Madhan Member Posts: 96
edited 2006-03-17 in NAV/Navision Classic Client
Hi Great day all,

I am just creating a report "Purchase register - consolidation" using Purch inv header and purch inv line table.

In that report, first i like to group by vat business posting group in the header and then by tax%, vat% in the line table.

so, i am grouping by vat business posting group in the header table and by tax%, Vat% in the line which i have set it in the group total fields of both dataitem correspondinly.

I have set dataitemtableview property also. But, the report is grouping only by vat business posting group and the group by fields which i have set in the line dataitem is not working.

can any help me.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    what keys have you set on the two dataitems?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Madhan
    Madhan Member Posts: 96
    VAT Business Posting Group in the header table (Purch Inv. Header)

    Tax% and VAT% in the line table(Purch Inv. Line)
  • somnathbasu9002
    somnathbasu9002 Member Posts: 47
    There is a function in Navision 'TOTALCAUSEDBY' which is very important for Grouping of data. Please try to use it. Meanwhile i am trying myself to solve the problem.
  • Madhan
    Madhan Member Posts: 96
    Thax a lot,

    I will try this and update you.

Categories