Groups with All Customers and Each Customer

[samiam07]

CRXi R2, MS-SQL05 (Xtreme.mdb for testing)

Sample: Xtreme.mdb using the Customer and Orders tables.

What I need to end up with is:
The group tree would show All Groups and then each customer. The All Group group would display each customer and their orders. Basicly a summary of all. Clicking on City Cyclists in the group tree would display the orders just for City Cyclists, and then the next customer and etc.

One solution is to use a subreport for the summary and the main report for each customer group. That would mean running the procs multiple times. A big hit on performance, since the final report will have about 100 customers, each with several hundred orders.

Is it possible to do this in one report pulling in a singel data set (or single query)?????

Thank you

 

[kskid]

On the left side of the report canvas, right click on Section Expert and hide the order section.

 

[samiam07]

I've worked on all versions of CR since v3 and have not seen an option to hide the order section.

What dialog box are you looking at?

 

[lbass]

I believe kskid is suggesting that you set up the report with a group on customer and then hide the detail section showing the orders. Then you can drilldown on any particular customer to reveal detail, but maintain the summary display.

Another option would be to display a crosstab in the report header to show customers and total orders, while the main body of the report shows customers with detail.

-LB