question

EdwinLaw-9551 avatar image
0 Votes"
EdwinLaw-9551 asked ZoeHui-MSFT edited

Setting column visibility in SSRS Report Builder

91360-screenshot1.png



Hi, This question is in regards to the behavior of SQL Server 2016 Report Builder. To hide a column in the report, I have tried setting the "Hidden" properties in the properties window to true. The result is I got white space painted over where the column would have appeared. Sure the column is hidden in a way but now there is this "gap" in the table. Please let me know if this is a known bug that will be fixed in a future version. For your information, when I right click the column and select "Column Visibility...", setting the expression there works seamlessly though)

Regards,
Edwin

sql-server-reporting-services
screenshot1.png (46.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
1 Vote"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @EdwinLaw-9551,

The row visibility hidden is different with the property hidden.

The Properties hidden is used to hide a report item.

The row visibility hidden is used to hide static rows in a table.

In other words, the Properties hidden can be use in single textbox in a table so that it will have "gap" in the table.

However the row visibility is only used in a row.

hide-an-item-report-builder-and-ssrs

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.