I am having problems trying to suppress a group and I am just not that experienced with CR so this just doesn't make sense to me why it won't work. I have two groups and depending on a parameter that gets passed to the report I want to suppress the outer group - not group the data.  The problem is that it is only suppressing the header and footer sections but the data still appears grouped. 

Here is an example.  Lets say I pass in a "Y" then I want to see the report like this where I have an outer group called Machine Type and then inside of that I have all the retailers that have machines of that type.
Machine Type1
  Retailer1
          Machine1    Serial#
          Machine2    Serial#
       Retailer Totals:
  Retailer2
          Machine1    Serial#
          Machine2    Serial#
       Retailer Totals:
  Machine Type1 Totals:
  
Machine Type2
  Retailer1
          Machine3    Serial#
          Machine4    Serial#
       Retailer Totals:
  Retailer2
          Machine3    Serial#
          Machine4    Serial#
       Retailer Totals:
  Machine Type2 Totals:


If I pass in a "N" then I don't want the data grouped at all by the Machine type and want to see all of the data grouped just by the Retailer like this:
  Retailer1
          Machine1    Serial#
          Machine2    Serial#
          Machine3    Serial#
          Machine4    Serial#         
       Retailer Totals:
  Retailer2
          Machine1    Serial#
          Machine2    Serial#
          Machine3    Serial#
          Machine4    Serial#         
       Retailer Totals:

But instead I am seeing this:
  Retailer1
          Machine1    Serial#
          Machine2    Serial#
       Retailer Totals:
  Retailer2
          Machine1    Serial#
          Machine2    Serial#
       Retailer Totals:
  Retailer1
          Machine3    Serial#
          Machine4    Serial#
       Retailer Totals:
  Retailer2
          Machine3    Serial#
          Machine4    Serial#
       Retailer Totals:

In the Section Expert I have the Suppress checkbox checked for the Machine Type group header and footer and then I have a condition specified "Type='N'"

So - what am I doing wrong??
Thanks

I used a formula like you suggested and it is working - Thanks for your help!!