Supression Formula

[tuber]

I have 2 groupings. I'm supressing the footer of the second grouping if the grand total is smaller than a parameter i provide. But I want to be able to supress group 1 if group 2 is supressed.

How can I do this. If you need more info please just ask.

[brucevde]

Suppress the Group 1 footer based on what?

There may be multiple Group 2 Footers per Group 1. Some of those footers might be suppressed others won't be.

[tuber]

Group 2 Footer contains the Grand totals for the values in the Group 1 Header. I have in the section expert to suppress Group 2 Footer if the totals is less than a # provided by the user. When they give the number the report loads but it will suppress the Group 2 Footer but not the Group 1 Header. I want to be able to when Group 2 Footer is suppressed suppress everything in that Group. I think this might be impossible to explain.

[brucevde]

Maybe a visual example would help. Using a typical Customer, Invoices scenario. User specifies 700 so only Order # 2 is suppressed.

GH1 - Customer Name, Total of All Orders 2700
  GH2 - Order # 1, Order Date
  GF2 - Total of Order 1 - 1200 of 2700
  GH2 - Order # 2, Order Date
  GF2 - Total of Order 2 -  500 of 2700
  GH2 - Order # 3, Order Date
  GF2 - Total of Order 3 - 1000 of 2700
GF1 - Total of All Customer Orders - 2700

With the above scenario when would Group 1 be suppressed? When all Group 2's are suppressed? For example, if the user were to enter 1500.

[tuber]

Sorry I didn't reply for so long, i meant no disrespect. I really just want when the Footer is suppressed the Head is suppressed as well

Count ({employer.Status_Code}, {employer.Status_Code}) < {?Number of Leads}

Here is my suppression formula for the footer. If Status Code is < than X then Suppress. then I want my header to be suppressed too if the footer is suppressed for that record.

[brucevde]

We are having trouble understanding each other. Your original post indicates you want to suppress the Group 1 Header if the Group 2 Footer is suppressed.

then I want my header to be suppressed too if the footer is suppressed for that record.

To suppress both the Header and Footer of the same Group, use the same suppression formula.