Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Sam Vanga

Sam Vanga helps business people solve their data problems and enables them make data-driven-decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at

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. :)



Leave a comment on the original post [, opens in a new window]

Loading comments...