Need summary in report header based on parameter

[kkinnea]

I have a problem I can't seem to find an answer to...

There have been many user requests for "roll-up" totals for all clients at the top of reports. Since the clients usually constitute a group, I have been creating subreports and placing them either in the report header or in the group header of a group with a formula as follows:

Select {field name}
default: "All"

A new wrinkle is that they don't want to see the totals for any other clients if they only choose one or 2 clients. I am at a complete loss as to how to do this. Any help would be greatly appreciated.

Thanks,
Kristen

 

[IdoMillet]

Kristen,

Just insert a CrossTab in the report header.

Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[kkinnea]

Ido,

Hey, what do you know! That works! It's not as easy to format, but will certainly solve my issue. I didn't even think about a crosstab to solve this.

Thanks again!

Kristen