Options

Multiple Grouping in Report

SoumyadipSoumyadip Member Posts: 209
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

  • Options
    randrewsrandrews 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
  • Options
    SoumyadipSoumyadip 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....
  • Options
    randrewsrandrews Member Posts: 135
    Change "Item No." on your field (for Example "City")
    CurrReport.SHOWOUTPUT((FIELDNO("Item No.") = CurrReport.TOTALSCAUSEDBY));
    
  • Options
    SoumyadipSoumyadip Member Posts: 209
    Thnx I Will Try It
  • Options
    randrewsrandrews 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
Sign In or Register to comment.