Suppressing one of 2 groups in Crystal Reports

[Sinead]

I have a report which has two groups in it. One is 'by Zone' and one 'by Day'. I want the report to group by just one of these groups, depending on which group the user chooses. However if I suppress one of the group headers it still groups by both. Can anybody help?

 

[Guest_imported]

Set up a parameter, where the entered data is the name of the group.

Then group by the parameter.

You may need to play


Regards



Jason
trainingjason@aol.com

 

[Ngolem]

Hi

create a formula called "Select Group"

***************start of formula************

if {?reportGrouping} = 1 then
{Field1}
else if {?reportGrouping} = 2 then
{Field2}
else
{Field1}; // have a default case to handle other numbers

***************end of formula************

then once created, Group only on this formula

Jim