How to set in Report the TextBox visibility by expression in VisualStudio?

Question

I have a simple TextBox in my Precision Design related to a Field in Temporary Table. I need to show this TextBox only If the it value under Temporary Table is pupulated : so if the value field is pupulated (is a string) I show the Text Box , otherwise I don't show the text Box.

I need to set Visibility by Expression :

Which is the best way forward over ?

Thanks!

Answer 1

You can use iif function. Press fx button, here you can writte your code.

iif function evaluate a condition and return 1 of 2 options, for example, in your case you need show one value only if exist.

check this code:

=iif(fields!YourFieldName.value = "", true, false)

if your field is a number

=iif(fields!YourFieldName.value = 0, true, false)

This code evaluate the value of your field and only populate the value if is complete.