Multiple Grouping in Report

Soumyadip
Soumyadip Member Posts: 209
edited 2005-04-06 in NAV/Navision Classic Client
Hi All,

I wanna have a report of customer grouped by
1. Country
2. State
3. City

something like this

Country State City NoOfCust
India
Delhi

Area1 10
Area2 12
Total 22

Karnataka
Area3 25
Area4 15
Area5 10
Total 40
Total 62

UK
State1
Area1 12
Area2 18
Total 30
Total 30


Can Anybody Help Me???

Thank You

Comments

  • randrews
    randrews Member Posts: 135
    Do you want to count customers by City?
    Then Key: Country,State,City
    GroupTotalFields: Country,State,City
    In trigers OnPreDataItem put 
    CurrReport.CREATETOTALS(Num);
    In trigers OnAfterGetRecord: 
    Num := 1;

    Thats all.

    Something like that i advised you in http://www.mibuso.com/forum/viewtopic.php?p=19005
  • Soumyadip
    Soumyadip Member Posts: 209
    Thnx..
    i defined a secondary key & put the fields(there are 4 fields) in "group by total".
    But in group footer the same record is comming 4 times...
    how to solve this....
  • randrews
    randrews Member Posts: 135
    Change "Item No." on your field (for Example "City")
    CurrReport.SHOWOUTPUT((FIELDNO("Item No.") = CurrReport.TOTALSCAUSEDBY));
  • Soumyadip
    Soumyadip Member Posts: 209
    Thnx I Will Try It
  • randrews
    randrews Member Posts: 135
    randrews wrote:
    Change "Item No." on your field (for Example "City")
    CurrReport.SHOWOUTPUT((FIELDNO("Item No.") = CurrReport.TOTALSCAUSEDBY));

    Forget to say - this code mast be in GroupFoter

Categories