Printable View
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.
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.
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.
Maybe a visual example would help. Using a typical Customer, Invoices scenario. User specifies 700 so only Order # 2 is suppressed.
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.Code: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
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
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.Code:Count ({employer.Status_Code}, {employer.Status_Code}) < {?Number of Leads}
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.
To suppress both the Header and Footer of the same Group, use the same suppression formula.Quote:
then I want my header to be suppressed too if the footer is suppressed for that record.