Group Total Fields in Reports

Madhan

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.

ara3n

what keys have you set on the two dataitems?

Madhan

VAT Business Posting Group in the header table (Purch Inv. Header)

Tax% and VAT% in the line table(Purch Inv. Line)

somnathbasu9002

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

Thax a lot,

I will try this and update you.