How do I display 'No data available.' when there are no rows to show on the report?
bids, reporting-services, reportingservices-2005
Solution
You could set the property `NoRowsMessage` available on the report's table control like this:
- Select the `Tablix` control and press F4 to view the Properties pane.
- Find the `NoRowsMessage` property and set the value to whatever message you'd like.
- You can also to format the message using the `Font` and `TextAlign` properties.
Here are some examples of what the report will look like under various settings:
Further Reading: Here is a Technet article on how to Set a No Data Message for a Data Region
Problem
I am building an SSRS 2005 report using BIDS. My report filters on date. When the selected date returns no data rows the report is blank, just the title is displayed, no table or column heading. How can I change this to display a message like `No data available.` or `Report is empty.`?