SSRS NoRows – Display a custom message when there is no data

In this short post, I’ll discuss NoRowsMessage property. When there is no data for a data region, the message you specify for the NoRowsMessage property will displayed to the user instead of a blank report.

I created a report with a tablix and configured the NOROWS property from the tablix properties window.


As with any other properties, you can give a static text or use expressions. The text I input here will be displayed when there is no data.



Report Preview:


For the record, NO, I wouldn’t use the message seen in the above image for my users and you shouldn’t too. 🙂