How do I set the visibility of a text box in SSRS using an expression?

by

I tried the example that you have provided and the only difference is that you have True and False values switched as bdparrish pointed out. Here is a working example of making an SSRS Texbox visible or hidden based on the number of rows present in a dataset.

Step-by-step process: SSRS 2008 R2

  1. In this example, the report has a dataset named Items and has textbox to show row counts. It also has another textbox which will be visible only if the dataset Items has rows.

  2. Right-click on the textbox that should be visible/hidden based on an expression and select “Text Box Properties…”. Refer to screenshot #1.

  3. On the Text Box Properties” dialog, click on “Visibility” from the left section. Refer to screenshot #2.

  4. Select “Show or hide based on an expression”.

  5. Click on the expression button fx.

  6. Enter the expression =IIf(CountRows("Items") = 0 , True, False). Note that this expression is to hide the Textbox (Hidden).

  7. Click OK twice to close the dialogs.

  8. Screenshot #3 shows data in the SQL Server table dbo.Items, which is the source for the report dataset Items. The table contains 3 rows. Screenshot #4 shows the sample report execution against the data.

  9. Screenshot #5 shows data in the SQL Server table dbo.Items, which is the source for the report data set Items. The table contains no data. Screenshot #6 shows the sample report execution against the data.

Screenshot #1:

1

Screenshot #2:

2

Screenshot #3:

3

Screenshot #4:

4

Screenshot #5:

5

Screenshot #6:

6

Leave a Comment