O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Testing reports

There are several common areas that should be tested and checked for each report. Here is a list of common items to test:

  • Date ranges should be tested for one day, one month, several months, one year, and sometimes multiple years. The user may say they only want a small date range, but after they get to like the report, they will start to use larger date ranges. Test the performance of the report as the date range increases. You may find that some reports can't be generated in a reasonable amount of time for large date ranges and a different solution may be needed.
  • Make sure a descriptive label is used for the date range parameter and is also placed on the report. This helps later down the road when the end user wants to compare ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required