Conditionally Suppress Group 1 via Parameter

[trbyrne]

First things first: CR 10, Developer Edition, WinXP platform

I am working on a report that has the following groups:

Group 1 - Location
Group 2 - Division (hide, DDOK)
Group 3 - Department (hide, DDOK)

Basically I am showing inventory levels by location and allowing the user to drill down into the details as needed.

What I *want* to do is give the user the option of *not* showing it by location (via parameter ShowLoc) and instead showing inventory levels corporate-wide. In my Suppress formula for Group 1 I've entered the following: "if not {?ShowLoc} then true". This works fine to suppress the group header and footer, but my divisions are still broken out by location like this (it's just that the location headers and footers are not shown):

Div 1 - 180,000
Div 2 - 220,000
Div 3 - 185,000
Div 1 - 80,000
Div 2 - 123,000
Div 3 - 95,000

Does anyone know how I can accomplish this task? Thanking you in advance for your assistance.

 

[IanWaterman]

YOu need to group on a formula which incorporates your param

@Group

If Param1 = @Location the LocationField ele DivisionField.

Change your location group to group on this formula and remove Division group.

Ian