This blog is part of my series Making Data Tell a Story With SSRS Properties.
The purpose of this property is to display a specific message when no rows are returned from a dataset to be displayed in a table, matrix, or list.
To access the property, select the data region and go to NoRowsMessage.
Example: I have a report that shows sales by territory by year. It has a parameter for the order year. When a user inputs a year that has no orders, it currently displays a blank table. The users have indicated this is confusing and have suggested the report is “broken”.
I go to NoRowsMessage and enter, “Year entered has no data. Enter another year.”
When the report is run, if a user enters a year that has no orders, the message is displayed.