suppress a grouping based on parameter

[jwaldner]

I thought I had this working in a report by using the section expert to add a formula similar to this in the formula to suppress a header or footer and suppress the drill down:

{?Grouping Options} <> 1

the header or footer cannot be seen but the drill down still shows the groups I am trying to suppress...

What I would like to do is not group the data by that group at all if the user chooses that.

Am I doing something wrong?

 

[lbass]

You shouldn't be suppressing, but instead, you should be grouping on a formula like this:

if {?Grouping Options} = 1 then
{table.field}

-LB

 

[jwaldner]

oh, that's almost too simple!