reporting services - How do I display 'No data available.' when there are no rows to show on the report?

Question

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.?

Answer 1

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