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!
Showing posts with label depending. Show all posts
Showing posts with label depending. Show all posts
Wednesday, March 21, 2012
Make Table not appear
Hello
I want to edit my visibility of a table depending on the number of rows
it has. i.e if there are no rows present I want to display a message
instead, so make the table invisble and make the message visible. Is
this possible if so how do I do it, my gues would be to count the
number of rows and display if greater then 1?
Any help would be greatly appreciated
DenverHi Denver.
The way I would go about doing this is by placing an iif statement in the
visibility section of the properties. This would basically specify true for
if there were no rows returned or false if there is data returned.
Regards
"Denver" wrote:
> Hello
> I want to edit my visibility of a table depending on the number of rows
> it has. i.e if there are no rows present I want to display a message
> instead, so make the table invisble and make the message visible. Is
> this possible if so how do I do it, my gues would be to count the
> number of rows and display if greater then 1?
> Any help would be greatly appreciated
> Denver
>
I want to edit my visibility of a table depending on the number of rows
it has. i.e if there are no rows present I want to display a message
instead, so make the table invisble and make the message visible. Is
this possible if so how do I do it, my gues would be to count the
number of rows and display if greater then 1?
Any help would be greatly appreciated
DenverHi Denver.
The way I would go about doing this is by placing an iif statement in the
visibility section of the properties. This would basically specify true for
if there were no rows returned or false if there is data returned.
Regards
"Denver" wrote:
> Hello
> I want to edit my visibility of a table depending on the number of rows
> it has. i.e if there are no rows present I want to display a message
> instead, so make the table invisble and make the message visible. Is
> this possible if so how do I do it, my gues would be to count the
> number of rows and display if greater then 1?
> Any help would be greatly appreciated
> Denver
>
Subscribe to:
Posts (Atom)