Set a table's visibility to false when it has no rows (in reporting services)
Is there a way to set a table's visibility to false, if the table has no rows?
I want to hide a table in Reporting Services when it has no rows.
Setting NoRows to ="" isn't sufficient in this case as space is still left for the table, and some of the table's formatting is still visible.
I'm using Microsoft Visual Studio / SQL Reporting Services 2005
Try setting the table's "Visibility.Hidden" property to this expression:
=CountRows() = 0
Found the answer on my own, it's pretty simple.
I found this article which mentions the CountRows() function.
So to set the Visibilty / Hidden property to hide when there are no rows, it's simply
= Iif (CountRows() > 0, false, true)