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

Sam Vanga's SQL

This blog is syndicated from http://svangasql.wordpress.com Samuel Vanga is a SQL Server developer. He is experienced in database and business intelligence development. His blog is on http://svangasql.wordpress.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...