Two levels of grand totals

[Alincon2001]

I have many Crystal reports (V7) with more than one level of grouping. I would like to have other-than-group-one totals at the end of the report, instead of just grand totals.
Example: I have a report that groups tenants by project and then by bedroom size and shows average rent, etc.
The grand total line shows the total of all tenants and average rent for all tenants.
I would like to see the bedroom size breakdown for all projects combined.
Thanks for your help.

 

[synapsevampire]

"I would like to see the bedroom size breakdown for all projects combined."

You can just right click the bedroom size field and select insert summary, this will allow you to create group or grand total summaries, inclusive of averages, which is what I assume you want - I need more specifics if otherwise.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Alincon2001]

I must not have explained well enough.
I have a report with two levels of grouping.
The first group is by housing project
The second group is by bedroom size.
There are totals at both group levels and at report end.
But the report totals are only one line, for all
projects and all bed room sizes.
What I want is end-of-report totals for all projects,
but by bedroom size.
What I do now is temporarily delete group 1 and rerun the report with only group 2.