Wednesday, March 21, 2012

Make textbox value dependent on result of a dataset

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!

No comments:

Post a Comment