Grouping on Multiple Fields based on Parameter

[rose4567]

Hello all,

I am trying to group my report by either
Department
or
Department AND Location.

Group Header 1: = Department (crosstab here)
Group Header 2: = Location (crosstab here)

I have a parameter that asks the user to choose the level of grouping. "Either Department" or "Department & Location."
Where Department is selected, I need ONLY Group Header 1 to display with crosstab.
Where Department and Location selected, I need BOTH Group 1 and Group 2 to display in tree hierarchy because each section contains a crosstab with different sets of data.

I have supression set in the Section Expert on the Group 2 (Location grouping level) "Supress (No drill-down)" and the formula for suppression is:
{?grouping} = False
LOGIC: False is set to Department, so this SHOULD suppress all locations.

The group hierarchy tree, however, STILL displays when I select group by department only. It displays the locations. If you click on them you only get Department data, but is there a way to suppress Group 2 entirely?

I thought by checking "Suppress (No drill-down)" that I would only get group 1 results and group 2 would not display at all, but that does not seem to be the case.

Also, and this may clear itself up with the grouping suppression, I have a group footer set to display with group header for each level of grouping and when I choose Department, the group footer does not display on the same page despite there being enough room and despite the "keep together" option being selected.

Thank you all in advance for your help!

[rose4567]

OK, I got the footer problem to go away so that is displaying correctly now. However, the locations in the tree hierarchy still show (even though if you click on them it still just displays the department data).

I guess if this is as good as it gets, then I can live with that. But preferably, when I select Department, I would like the tree hierarchy displaing locations to not show at all.

[mabbas110]

I think u have to try with soem other method. What u do is make a formula in which u select that if parameter1=1 then location else location+department.

pass parameter1 from form as selected by user. and then see that if u can get ur desired result.