Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Reporting Services - Nothing to see please move along

Reporting Services - Nothing to see please move along

  • Comments 2
  • Likes

Sometimes when you run a report it’s not going to return any rows, perhaps because the user selected a filter for which there is no data, and that needs to be handled properly.

Fortunately there’s a simple way to  control the messaging when this occurs to ensure your users know what’s happened and don’t assume it’s all your fault.

For the tablix data region, chart or sub-report go to the properties for it and enter an appropriate message as shown below..

image

If you don’t see the properties in Report Builder 2 got to view and check the properties option..

image

So like any kind of development (in BI analysis services would be a good example) it’s important to review the properties and ensure you get the behaviour you need .

Comments
  • Andrew Fryer has info on his blog showing how to set SSRS to display that no data was found instead of

  • Thank you Andrew for your tips!

    This is good to know.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment