Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

Figure 12-32. Actions available for a report rendered in SharePoint

Creating a Simple Dashboard to Display SSRS Reports

Now that you have successfully deployed and rendered reports in SharePoint and have seen many of the

attributes and actions available, I’ll show you how to create a dashboard that can render the reports in a

concise Web Part. The SQL Server 2012 Reporting Services Add-In that you installed previously included

the SQL Server Reporting Services Report Viewer Web Part. Creating a dashboard is as simple as clicking

the Dashboards link in the web site and then selecting the New Page option under the Site Actions link

button. You will provide a name for the new dashboard link and the initial layout based on a template.

For example, I chose to name the dashboard Admissions. Once the dashboard is created, you can

navigate to it and edit its design directly in the browser. Click Web Part on the Insert tab while in edit

mode and select the SQL Server Reporting Services Report Viewer from the list of available Web Parts, as

shown in Figure 12-33. You will find it in the SQL Server Reporting category. After you have it selected,

click the Add button.