ssrs reporting on reports n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
SSRS: Reporting on Reports PowerPoint Presentation
Download Presentation
SSRS: Reporting on Reports

Loading in 2 Seconds...

play fullscreen
1 / 14

SSRS: Reporting on Reports - PowerPoint PPT Presentation


  • 103 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - 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)