Hide SSRS textbox based on an expression

Hello everyone,

In this small post I will talk about how to Hide SSRS textbox based on an expression .

  • Right click on your textbox and click Text Box Properties (The left side arrow on the below picture):

 

  • Then click on Show or hide based on an expression radiobutton from the Visibility tab.
  • Click on fx button to write your expression (you should write your expression for hiding textbox).

In my case I wanted the textbox to be hidden if its value is an empty text. In order to achieve my purpose I wrote below code:

 

You can write you own expression with the help of Operators and Common Functions (which I marked with red arrow on the picture above).

Hope this helps.

 

Leave a Reply

Your email address will not be published. Required fields are marked *