I am using SSRS 2008.
We currently have a number of reports which often have several tables stacked one above the other.
In many cases the data supplying one or more of these individual tables returns no rows. Rather than inform the user of this using the no rows message options we simply hide the table since there is no reason for displaying the column and field labels with empty
data as this is a waste of space depending on the report in question.
In our SSRS2005 reports we often checked the primary key of the tables dataset by comparing it to NOTHING,
example: Visability: Hidden = IIF(primary_key = NOTHING, True, False)
But when we converted these reports from 2005 to 2008 this became unstable. Sometimes it works, sometimes it does not.
What I am hoping to find out is the most stable, if not Microsoft-recommended, method for hiding a tablix(table, matrix or rectangle) if there is no data?
I have seen the use of the rowcount option, but I would like to determine if this is the preferred practice before implementing it accross the board on our reports.
All help is appreciated.
View Complete Post