I need to make a textbox1 say "Pass" or "Fail" depending on the value in
 another textbox2. Textbox2 has an expression assigned to it:
 =Sum(Fields!TotAgents.Value, "NumAgts") which returns a 0 or greater number.
 I am struggling with the syntax of linking the textbox1 text to the result of
 textbox2's evaluation. In otherwords, if textbox2 evaluates to 0, then
 textbox1 should say "Pass".
 Thank you.Try this:
Right click on textbox1 and choose expressions.
Type: IIF(Fields!TotAgents.Value = 0, "Pass", "Fail")
This should give you the word "Pass" if the value in textbox2 is = 0
and the word "Fail" if the condition is not met. Hopes this helps!
Wednesday, March 21, 2012
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment