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 http://SamuelVanga.com.

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.

image

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.

image

 

Report Preview:

image

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

@SamuelVanga.


Comments

Leave a comment on the original post [svangasql.wordpress.com, opens in a new window]

Loading comments...