Multi grouping in the reports

ebrahma

hi,


How to do multiple groupings in Navision reports ?

Ex:

Group 1: Zone

Group 2: State 1

Group 3: District 1

............Sales.................

Group 3: District 1 sales Total


Group 3: District 2

............Sales.................

Group 3: District 2 sales Total

Group 2: State 1 sales Total

Group 2: State 2

Group 3: District 4

............Sales.................

Group 3: District 4 sales Total


Group 3: District 5

............Sales.................

Group 3: District 5 sales Total


Group 2: State 2 Sales Total

Group 1: Zone total

StephenG

Hi!

Are you using one Table?

If so then you need to set the Current key to an appropiate key which contains the fields you want to group by.
You should also use dataitem property GroupTotalFields and fill it with the fields you want your records to be grouped by. Then you can control which groupfooter/header you need to print with code in the OnPreSection of the GroupFooter/Header Sections.

CurrReport.SHOWOUTPUT :=
CurrReport.TOTALSCAUSEDBY = "Record".FIELDNO(Zone);

Hope this will help.

eromein

Make sure the table has a key with all fields (you wanna group on) in it.

Then just run the report wizard and give the right answer to the right questions....

that should be enough!

ebrahma

Thnaks for reply