Displaying custom messages in SSRS
Blog
  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

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.

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 🙂

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