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