Grouping Instead of SubReports

[OldSkoolSkater]

I have a report that has three groups Planner, Supplier and Item. Within each of these groups I would like to place a summary (count of certain items). So within the Planner header I would like to list all the suppliers for that planner, and then within the supplier group I would like to list all the items.

I have managed to do this with sub reports, but this does not give the drill down facility that the end user wants.

Anyone got any ideas?

 

[kenhamady]

Have you tried adding cross-tabs or a group chart in the group headers? You can't drill down from the Cross-tab cells, but you can drill down from a group chart.

You already have the three group levels which can be set up for drill down. What did the subreports do that the three groups you now have don't allow? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[OldSkoolSkater]

I tried a crosstab - but the information I want to display in each summary, is based on the group ie: for one planner display all the suppliers but alongside each supplier I wanted to count the number of records that met a certain criteria. (I've done this by doing - if critiera is true then 1 else 0 and then summing this formula)
ie :
Planner 1
Cancelled Moved Signed
Supplier 1 0 1 3
Supplier 2 2 3 2
Supplier 3 1 4 2

and then allow the users to double click (info desktop - viewer) on the supplier to drill down and display one supplier, with a summary of the items again with the same count.

The subreports did not allow me to drill down to the next level, it just displayed the subreport as a separate sheet

Hope I've explained this okay.

 

[kenhamady]

1) Subtotal your formulas by supplier and by item.
2) Suppress the details, Supplier GH and Item GH
3) Hide Item GF

This will give you the summary of suppliers for each planner, and then you can drill down to the item totals for each supplier. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)