SSRS and SharePoint ‘The Right Way’ Slidedeck and Notes


Here are my notes and slide deck from this past weekend’s presentation at SharePoint Saturday Sacramento on SQL Reporting Service and SharePoint integration ‘The Right Way’.

Q&A Responses

  • How do I prefilter a report?
  • To prefilter a report you use the syntax &param=value at the end of the url, for example if I have a parameter of Distance and I want it to be 10 (maybe 10 miles). You can append &Distance=10 to the end of the url.
  • Where can I get copies of the reports used?
  • To download the example reports used, visit: http://go.microsoft.com/fwlink/?LinkId=87843

Download slidedeck: SPS-Sac-SSRS-The-Right-Way.pptx

Slide1

So, why do we want to have SSRS, or BI tools in general, integrated directly in to SharePoint? SharePoint is typically pushed as the one-stop shop for all of your internal business information, whether this is structured information or unstructured like Office Documents. So when we go to SSRS and attempt to integrate in to SharePoint we have a couple of benefits and a few potentially major downsides. The benefits I’ve outlined here are what we get with SSRS in SharePoint Integrated mode. We get a simple document library style view for creating, browsing and viewing available reports. Sounds great so far.

Slide2

However, we have a few key issues with how SSRS in SharePoint Integrated mode works. Depending on where you are in your SharePoint and SSRS BI implementations these can be show stoppers before your project has even hit the ground. The key downsides largely are around that SSRS requires SharePoint to be installed on the same physical system as itself. Additionally this SharePoint install has to be a member of your SharePoint farm. Also in the process of this setup all of the standalone SSRS capabilities get either augmented or removed altogether. The SSRS administration site where you manage permissions, and scheduling of building reports to ensure QOS is removed. And only the permission management piece remains in the SharePoint interface. If you have an existing investment in SSRS and/or SharePoint this is a major stopping point for most companies. However, I have good news, you can mimic all of the SSRS SharePoint Integration without having to follow the SSRS+SharePoint on the same box requirement. Without sacrificing anything in either world, or augmenting your existing SharePoint or SSRS systems.
Slide3Demo Site – http://ms-sp2010-dev/SSRS

Page Viewer web part of full uiQuick launch or summary link web part for presenting individual reports as popups or embedded view page viewer
C:\Program Files\Microsoft SQL Server\MSRS10_50.SSRS\Reporting Services\ReportManager\Pages > Copied Folder.aspx, Renamed Library.aspx

Added following style:<style>table.msrs-topBreadcrumb, table.msrs-header { display:none;}</style>

 

  1. No comments yet.
(will not be published)


%d bloggers like this: