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

reporting-services reportingservices-2005 bids
Tony Borf picture Tony Borf · Apr 13, 2012 · Viewed 47.6k times · Source

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

user756519 picture user756519 · Apr 13, 2012

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.
    • Set no rows message

Here are some examples of what the report will look like under various settings:

example

Further Reading: Here is a Technet article on how to Set a No Data Message for a Data Region

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
Passing parameter via url to sql server reporting service

I'm trying to pass a parameter via the url to SSRS and it appears not to work! I'm trying to pass a userId (string) via the url which will be passed to the database and used by the query. base …

Read More
How to get named excel sheets while exporting from SSRS

Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify sheet names in …

Read More