Conditional suppression for a text box on grouping

[littleress]

I have a report that does totals for lots of different people. So they are grouped by id and the report totals 3 different tables and the theory is that all three end totals of several different groups should match. ex

payments 10 10 10
products 5 5 5
misc 8 8 8
ID 1 Total 23 23 23

payments 15 10 15
products 10 10 10
misc 5 5 5
ID 2 Total 30 25 30
Lots of other clubs.......
All Total 1000 895 1000

I may have 200 id's and so when I see that the total is off I want the club to be highlighted. Was thinking maybe a text Box that was red with **** so I'm not looking through pages of data looking for the 1 or 2 clubs that are off but instead the club would jump out at me.

There are 2 groups, a total of the items, and then a total of the total of items. I need this text box to be suppressed except when a club is off - like club 2 is off in the middle column. I've tried the suppression but I don't know how to tell it which group sum to look for.

Does this make sense what I'm looking for? I'm just not sure how to conditionally suppressed based on a groups total.

Was thinking under suppression
if ((sum1=sum2)and (sum2=sum3) and (sum3=sum1)) then true...
But that doesn't say which group of sums.

Any help would be great!

Thanks in advance!!!

 

[solmskid]

if the three column totals for the ID group should always be equal and you are displaying the data in the ID group footer you could do this:
create a formula (COLTOT) that adds the totals of the three columns, then in the section expert for GroupFooter1 select the color tab, select the conditional box and add this formula:
IF REMAINDER (COLTOT,3) = 0 THEN DEFAULTATTRIBUTE ELSE CRYELLOW
this will change the color of the groupfooter only when sum of the three columns does not divide evenly by 3.

-solmskid

 

[lbass]

I would use group selection instead of suppression. Go to report->selection formula->GROUP and enter:

sum({table.col1},{table.id}) <> sum({table.col2},{table.id}) or
sum({table.col1},{table.id}) <> sum({table.col3},{table.id}) or
sum({table.col2},{table.id}) <> sum({table.col3},{table.id})

...where {table.id} is the ID field you are grouping on.

-LB