Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

Now that you are done with all of your setup and configuration, it is time to move forward and show

you how to deploy reports to a SharePoint site.

Deploying Reports in a SharePoint-Integrated SSRS Installation

Once the three management tasks have been completed, it is time to begin working within the

SharePoint site itself, where you will work with deployed reports and dashboards to create a portal page

for your users. In our organization’s case, we wanted a simple Admissions dashboard page where

company executives and decision makers could review important BI reports concisely. SharePoint

provides many templates and samples that you can use to aid you in designing your dashboard.

Let’s take a look at a default SharePoint page. You can see in Figure 12-26 that a base SharePoint site

collection installation includes a Document Center. To centralize our deployment location, we created a

Reports Library. We also created another site on our SharePoint system using a built-in SharePoint

template called Business Intelligence Center, which will allow us to use web parts to create a sample

dashboard.

Figure 12-26. SharePoint Document Center main page

Figure 12-27 displays the Business Intelligence Center for SharePoint 2010. The name Business

Intelligence Center should not lead you to believe that this is where all of the SSRS reports will be