In the new SQl server 2012 Denali SSRS is integrated in SharePoint 2010 as a Service application. This has few benefits over the old SSRS
- Easy deployment of SSRS reports in SharePoint 2010 server.
- Since SSRS is an Service application and now has its own database (like any other service application database).
- Administrators can now perform all the day-to-day activities like backup\restore of SSRS applictaion database, checking uls logs using Powershell etc.
- Supports WCF and Claims based Communication, built-in Scale with load balancing, PowerShell commandlets and cross-farm report consumption.
- Alerting is a new capability that has been introduced to Denali Reporting Services. You can now setup alert rules and be alerted when report data changes occur that match a set of rules.
- Denali is using Visual Studio 2010 so new reports can be build in Visual studio 2010 and published to SharePoint
Once you have configured SSRS service application you can use various available tools to create and Publish interactive reports in SharePoint 2010. Lets look at some of these tools
Report Builder 3.0 - Report Builder 3.0 is a tool which is Integrated in Denali and is used for creating and Publishing Interactive reports to a Reporting server like SharePoint.You can quickly start building reports in Report Builder by creating and publishing report parts,shared dataset, Creating Table, Matrix, Chart wizard or using Map wizard to create aggregated data reports into the SharePoint server.
Report Builder and SharePoint 2010 - When SSRS is integrated with SharePoint “Report Builder” is available as a Content type. You can create a library and start using Report Builder as a content type in your library.
Creating a new report with Report builder Content Type – Once you add the “Report builder” content type to your library you can simple launch the Report builder tool\wizard by New Document item menu on the Ribbon and select “Report Builder Report”.
Power View or Project Crescent - Power View is feature of Microsoft SQL Server 2012 Denali which serves as an Add-in for Microsoft SharePoint Server 2010 Enterprise Edition to build reports with an excellent data exploration, visualization, and presentation. Project Crescent runs in the browser and is working against a BI Semantic Model (BISM). BI Semantic Model is available on the client through the Excel based Power pivot modeling tool or on the server through Analysis Services Tabular project with SQL Server Denali.
Check Out the System Requirements for Power View Here.
Lets look at some of the advantages of using this new tool -
- Power View is a thin web client that launches right in the browser from a tabular model in SharePoint Server 2010.
- In Power View you’re working with the real data.
- You can simply drag-drop various controls to Power View designer and create presentable reports in minutes.
- In Power View, you can quickly create a variety of visualizations, from tables and matrices to bubble charts and sets of small multiple charts.
- Project Crescent is optimized for design and online screen consumption and interactivity.
Now, you can get all new features in SQL 2012 Hosting with us. Click here to visit our site.