Blog Post

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.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating