CHAPTER 10 MANAGING REPORTSsample reports are useful for giving administrators information, such as report execution by user and
report size, among other things. You will find three SSRS execution log sample reports in all. One of
these, Execution Summary, is shown in Figure 10-26.
In prior releases of SSRS, Microsoft has provided a set of sample reports that you can use to report
data from the ReportServer database in conjunction with an SSIS package that can be used to transfer
the data. However, as of today, no new version has been created for the 2012 release. As such, we have
created a sample Execution Summary report that gives us a few meaningful metrics that our
administrators want to keep an eye on. Some of those metrics include total number of executions,
successful executions, failed executions, and number of executions by day number of the month.
Figure 10-26. Execution Summary sample report