Suppress one group if another group is suppressed
I have a report with 3 groups. I have the third group being suppressed if their are no totals displayed for that group. What I want to do is suppress the first 2 groups if group 3 is suppressed. In other words, if group 3 is suppressed, then suppress groups 1 and 2.
I have looked in these forums and thought that I found a way to do it using the Count() function, but it does not work. What I tried to do is do a count within group 3 and then do a suppression function on groups 1 and 2 that basically said that if the count() IsNull (this function could not be used in the suppression formula) then suppress the groups. Next, I also tried the count but said that if the count is greater than 0, then suppress the group. But, if the group is suppressed, then it does not count anything. Therefore, it is not greater than 0.
I have tried counting all of the fields in group 3, but I come up with the same results; no suppression.
Basically, I created a formula field that checked to see if the field exists, then, I tried counting the field. I created the formula field and placed it in the group. The field could be a text or number field; it did not make a difference, I was trying to check if it existed or not.
formula: If <field> <> "" then 1 else 0
suppression formula for groups 1 & 2: Count(<formula>) > 0
This did not work. If never suppressed groups 1 and/or 2.
Please help me. If I need to clarify anything, don't hesitate to ask.
Thanks,
grmrpr
[1548 byte] By [
grmrpr] at [2007-11-20 0:40:25]
# 2 Re: Suppress one group if another group is suppressed
I am able to suppress group 3 with a formula that basically looks at each groups beginning and ending balance, and, if it is 0, then suppress that group.
The problem is there could be multiple group 3's the group 2. And, there could also be multiple group 2's in group 1. Therefore, I can not use the same formula because I want it to look at ALL of the group 3's (if there is a multiple amount of groups) and if there is NO group 3's at all then suppress group 2. And if there are no more group 2's, suppress group 1.
For example, this report is using the Finance Chart of Accounts. The groups are Fund (group 1), Account (group 2), and Program (group 3). So the groups might look like this:
- (group 1) 11101
- (group 2) 10001
- (group 3) 2000 (This group has a beginning and ending balance - if there is no beginning and ending balance, this group is suppressed)
- (group 3) 2001
- (group 2) 10002
- (group 3) 2000 (Different group 2, so group 3 can also be 2000)
Now, what I want to happen is that if there are no group 3's under group 2, then suppress the group 2 because I do not need a heading with no amounts underneath it. But, there could be other group 2's and group 3's under group 1. But, if there are no group 3's at all under group 1, which would also mean there are no group 2's, then suppress group 1, 2 and 3.
I hope this helped to better clarify the problem. If not, I can re-explain it another way.
Thanks for any and all suggestions,
grmrpr
grmrpr at 2007-11-9 14:07:20 >
