1 / 14

SSRS: Reporting on Reports

SSRS: Reporting on Reports. Rick Krueger (@DataOgre) Dave Valentine (@IngeniousSQL). Public Service Announcement: Networking. Rick Krueger Twitter: @ DataOgre Blog: www.premierapps.com Email: rick@premierapps.com Dave Valentine Twitter : @ IngeniousSQL Blog: www.IngeniousSQL.com

marla
Download Presentation

SSRS: Reporting on Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SSRS: Reporting on Reports Rick Krueger (@DataOgre) Dave Valentine (@IngeniousSQL)

  2. Public Service Announcement: Networking Rick Krueger • Twitter: @DataOgre • Blog: www.premierapps.com • Email: rick@premierapps.com Dave Valentine • Twitter: @IngeniousSQL • Blog: www.IngeniousSQL.com • Email:Dave.Valentine@IngeniousSQL.com Dave Valentine (@IngeniousSQL)

  3. Agenda • ReportServerTempDB & ReportServer • ExecutionLog3 • RSExecutionLog • Reports • Wrap Up Dave Valentine (@IngeniousSQL)

  4. ReportServerTempDB • Current Activity • On Demand Reports • Cached Reports Dave Valentine (@IngeniousSQL)

  5. ReportServer • Main store for Reporting Services • Completed Report Execution • ExecutionLogStorage (don’t query, use views) • ExecutionLog (backward compat) • ExecutionLog2 (SQL 2008) • ExecutionLog3 (SQL 2008 R2) • Not all Report Execution is logged Dave Valentine (@IngeniousSQL)

  6. ExecutionLog3 • TimeStart • TimeEnd • TimeDataRetrieval • TimeProcessing • TimeRendering • UserName • ByteCount • RowCount • AdditionalInfo • InstanceName • ItemPath • Source • RequestType • Format • Parameters • ItemAction • Status • ExecutionId Dave Valentine (@IngeniousSQL)

  7. RSExecutionLog • CodePlex: Server Management Sample Reports for 2005 (10 reports) and 2008 (3 reports) • http://msftrsprodsamples.codeplex.com/ • Scripts to create supporting object, SSIS package, and sample reports • Download not available for 2008 R2 Dave Valentine (@IngeniousSQL)

  8. RSExecutionLog: Database Diagram Rick Krueger (@DataOgre)

  9. RSExecutionLog: Dimension Values Rick Krueger (@DataOgre)

  10. RSExecutionLog: SQL 2008 R2 • Download not available for 2008 R2, but upgrade path has been documented by others: sqltwist.com/archives/197 • Documentation not quite right (for my box), so providing download • Scripts for objects • SSIS Package Rick Krueger (@DataOgre)

  11. Reports: Canned Samples Rick Krueger (@DataOgre)

  12. Reports: Eleven (bit.ly/9SPUYJ) Dave Valentine (@IngeniousSQL)

  13. Wrap Up • ReportServerTempDB and ReportServer • RSExecutionLog • Eleven • Five reports as of August 2012 • Eleven reports by December 2012 • SQL 2012 version by December 2012 Dave Valentine (@IngeniousSQL)

  14. Questions & Discussion Rick Krueger • Twitter: @DataOgre • Blog: www.premierapps.com • Email: rick@premierapps.com Dave Valentine • Twitter: @IngeniousSQL • Blog: www.IngeniousSQL.com • Email:Dave.Valentine@IngeniousSQL.com Dave Valentine (@IngeniousSQL)

More Related