Creating a report with N level of Groupings

[victorCsharp]

I currently have an OLAP tool that groups data and produced "totals" that are not sums, but special calculations.
Reports can have more than one level of groupings.
I am using Crystal Developer's version XI. I can shape the data any way I want to. Currently I am trying to create ADO recordsets.
What is the best way of doing this?
I would use nested subreports but Crystal does not allow this.
TIA,
Victor

A sample report would be as follows:
Grand Total - Some Internally Calculated Number
Country1 - calculated subtotal Number
City1 - calculated subtotal Number
Client1 - value
Client2 - value
City2 - calculated subtotal Number
Client3 - value
Client4 - value
Country2 - calculated subtotal Number
City3 - calculated subtotal Number
City4 - calculated subtotal Number

 

[lbass]

To get the layout you are showing, you would place the client and value fields in the detail section, and then insert a group on country and then on city. If you were simply summarizing the detail level value field, you would right click on it and insert summaries at the group level and also a grand total. If you are doing something more complex, you should share the content of the formula you are using for your special calculation.

-LB

 

[victorCsharp]

The calculation of the total is being done in my program which is a COM server. I cannot do this in Crystal.
I have the calculated Total in my program. I can expose to Crystal any way that Crystal would consume it.
The question is how does Crystal want this?
Thanks,
Victor