Doug Lane

SQL Server Entertainer

  • GitHub
  • LinkedIn
  • Twitter
  • YouTube
  • Blog
  • About Doug

How to tell if a report is empty without opening it

November 16, 2010 by Doug Lane

Report Half Full
I prefer to think of the report as half full.

Once in a while, I’ll run a scheduled report and for whatever reason, the report won’t return any data.  It ran just fine — no errors, no failures — but there’s just no data in the body.  The reports are saved into various folders on the network.  In thumbing through these folders, I can spot the reports that ran with no data quickly.  It’s the ones that have a certain file size.

In my case, the report in question renders at 67 KB if it’s empty.  Dashboards with graphs, sparklines, and other fixed-size objects will show a little variance in size if a section is empty.  Table rows, on the other hand, will have a much greater impact on the file size when they are populated.  The exaggerated file size difference then makes spotting the blank ones much easier.

So, next time you open a report and you find the content to be empty, take note of the file size.  That number will raise a red flag for you whenever you see it and hopefully help you to catch (and correct) it before your users do.

Filed Under: Reporting Services Tagged With: ssrs, tips

Subscribe now!

Don't miss new posts as they publish. Enter your e-mail address to subscribe!

Your e-mail address will stay quietly between us, like that time I set the carpet on fire by accident.

Copyright © 2025 · Outreach Pro on Genesis Framework · WordPress · Log in