Set a table's visibility to false when it has no rows (in reporting services)

reporting-services report reportingservices-2005
Sophia picture Sophia · Feb 5, 2009 · Viewed 91.7k times · Source

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

Answer

Matt Hamilton picture Matt Hamilton · Feb 5, 2009

Try setting the table's "Visibility.Hidden" property to this expression:

=CountRows() = 0

Related questions

Fast query runs slow in SSRS

I have an SSRS report that calls out to a stored procedure. If I run the stored procedure directly from a query window, it will return in under 2 seconds. However, the same query run from an 2005 SSRS report takes up …

Read More
Compare SQL Server Reporting Services to Crystal Reports

Which of Crystal Reports and SSRS (SQL Server Reporting Services) is better to use?

Read More
SSRS Format to display as percent

I've gone through quite a few examples on here and I apologize if I'm asking a repeat question, as far as I can tell, I am not. I have an SSRS report made that shows gross sales for certain aspects …

Read More