Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report with N level of grouping and custom sub totals

Status
Not open for further replies.
victorCsharp

victorCsharp

Programmer
Jun 29, 2005
3
US
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
 
Status
Not open for further replies.

Similar threads

Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
643
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
608
Ivan Kok
Ivan Kok
sal21
  • Locked
  • Question
create report without database in vb 6.0 and recordset
Replies
0
Views
632
sal21
sal21
CrystalUser90
  • Locked
  • Question
Same field on two tables, merge into one field on report 1
Replies
2
Views
623
CrystalUser90
CrystalUser90
RenaG
  • Locked
  • Question
Max number of tables in the datasource for Crystal Reports
Replies
0
Views
119
RenaG
RenaG

Part and Inventory Search

Sponsor

Back
Top