O'Reilly logo

Reporting with Microsoft SQL Server 2012 by Bill Anton, James Serra

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

Reporting scenarios

Which is the best reporting tool for the job? The following are various reporting scenarios you may encounter and our suggestions on the best tool to use along with the reasons why:

Scenario 1

You want the reports to be created automatically and delivered via e-mail to certain users every morning. For such reports, you will pass in certain parameters such as country codes and the beginning and ending dates.

Solution: Since Power View does not support scheduled rendering and delivery of reports or parameter passing, SSRS is the reporting tool to use in this situation. In fact, this is what SSRS excels at thanks to the sophisticated subscription feature. This feature allows you to register with a publisher to get any report on ...

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