CR 11 - Possible to change grouping with a parameter?

[azoe]

I have a report that groups by month and then by financial class then by payer, etc..

Sometimes they want to see the data by financial class as the first group. I know how to suppress the month with a parameter but the group is still there so if a certain financial class appears in more than one month the financial class appears twice.

They want to be able to "roll up" the financial class into one. The grouping is done in Crystal reports and not in the stored procedure.

So instead of:

January
fin class 1
1,000.00

February
fin class 1
1,500.00
They want to see:

fin class 1
2,500.00

Is that something that can be done with a parameter?

Thanks -

 

[lbass]

Create a formula:

if {?parm} = "Month" then {table.date} else date(0,0,0)

Insert a group on this formula (setting it to print on change of month) and then insert a second group on class. Insert summaries on your amount field at both group levels, but conditionally suppress the month total by right clicking on it->format field->common->suppress->x+2 and entering:

{?parm} = "Class"

Or you could conditionally suppress the month group header using this formula in the section expert.

-LB