Multiple Grouping in Report

Soumyadip

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

randrews

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

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

Change "Item No." on your field (for Example "City")

CurrReport.SHOWOUTPUT((FIELDNO("Item No.") = CurrReport.TOTALSCAUSEDBY));

Soumyadip

Thnx I Will Try It

randrews

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