Report-builder: How to show the labels in a List when the dataset is empty

report-builderssrs

An equivalent question was answered for a tablix, but I would like to do this for a list:
"how to keep the structure of a tablix where there is no data".

I am showing about half a dozen fields in the list, each with their own label (which I want to repeat for each row).
If there are no rows, the user would like to use the report as a "template" that can be filled in manually so I would like to print the labels at least once.

How to keep the structure of the Tablix when there is no data to show

Best Answer

Occurs to me that I can do this by adding an empty record if the select returns no row; is that the best option?

Related Solutions

SQL Server 2008 R2 – How to Keep the Structure of the Tablix When There is No Data

You can add a row outside of the outermost group right under the tablix header row.
enter image description here

Set the row visibility to Show or hide based on an expression. The expression would like like:

=iif(CountRows("DataSet1") > 0, true, false)

When there is no data, the table will show the headers and empty row.

enter image description here

When there is data, the empty row will be hidden.

How to get past the 5000 row limit in a SQL Server Reporting Services tablix report

This turned out to have nothing to do with the Microsoft side at all. The data source we are using is a linked server to Proficy Historian and, by default, only pulls 5000 rows. You have to explicitly tell it either how many rows you want to pull, or tell it RowCount = 0 for unlimited rows. Sorry for the noise!

How To Set Rowcount in Historian OLE DB SQL Query

Best Answer

Related Solutions

SQL Server 2008 R2 – How to Keep the Structure of the Tablix When There is No Data

How to get past the 5000 row limit in a SQL Server Reporting Services tablix report

Related Question