This is part 4 of the 4 part blog series based on session by Peter Myers in TechEd 2011 . You can find the slides here. I have taken the key learning from the presentation for my future reference. For Part 1 or Part 2 or Part 3 go here or here or here
SQL Reporting Services can be integrated with SharePoint 2010 with Web Parts. Report Builder 3.0 is a rich client authoring tool that can be installed right from SharePoint. Reports can be saved in SharePoint library and the management and delivery functions of Reporting Services is available within the SharePoint interface. The advantages of using SharePoint deployment in Reporting Services is that it enhances team collaboration and versioning of reports.
Report Builder 3.0 Interface:
Insert a Map:
Integrated with Bing Map:
Use existing queries to pull the data in for the report.
You can create relationships between spatial and analytic data: In the below example map STATENAME to State:
Note the mapping:
Apply Data Visualization: Lower the sales, lighter the color; Greater the sales, darker the color.
Overlay the state code if needed:
Create Tooltips using the expression builder so that when the user hovers over the state, the tooltip will display the state and the number:
When you run the report, note the Time Filter you got by just checking the parameter checkbox:
Note the tool tip:
Save the Report to the Report Library:
Back in the SharePoint, the report is visible:
This report could also be added to the Presentation Point Service Dashboard and integrated with KPIs.