Is there a way to use the Groups Results of a text box to set the Background of another Text Box
I have calculated national results in an expression in Group 1 and I want to compare the Regional results in Group 2 to Group 1 and set the background Red or Green based on the compariosn, Is there a way to do that?
May 25th, 2011 10:37am

Yes you can use an IIF statement. If you click on the drop down and select expression you can enter something like this. IIF(CALCULATION_FROM_GROUP1 < CALCULATION_FROM_GROUP2, "Red", "Green") Hope this helps Baz
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2011 11:17am

Is there a way to define the Text Box as a calculation and then enter the textbox name in the logic statement? Dave
May 25th, 2011 11:18am

No I am afraid thats not possible :-/ the only alternative I can think of is to carry out the calculation in your SQL query then reference that within the IIF statement. Baz
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2011 2:55pm

I was afraid that would be the answer Thanks - Dave
May 25th, 2011 4:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics