Data & Intelligence

Displaying Custom Messages in SSRS.

SSRS is a powerful tool not because it projects queries in really good looking charts but because it enhances user experience.  The reports are so intuitive that users can navigate and export data without much training.  However, as business analyst or data analysts or report designers, it is our responsibility to extend these usability features to our users at every step.

We know that if sql returns no rows, SSRS will display empty tables to our customers. As a report designer and a user myself, empty table would worry me and would force me to think that reports are not pulling data correctly. Instead, I would like to see or show a clear message indicating why there is no data.  For example: No records found and so on.

Lets see how to add custom messages in SSRS.

For illustration, I have created a dummy table that contains 3 Columns:

1.)    Product

2.)    Product_Detail

3.)    Count

cm1

 

 

 

 

 

In order to add a custom message:

1.)    Select your table

2.)    Go to Properties

3.)    Scroll down to No Rows Message and Type Your Message in the Box.

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

cm2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

You can also change the Color and Font in the No Rows Section of the Table Properties.

This is how my report looks after I add my No Rows message J

cm3

 

 

 

 

Stay Tuned for more 🙂

About the Author

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up