This time, I'm going to speak about Reporting Services (SSRS) and some new features.

Power View


With his new file format RDLX, Power view is a new interactive BI feature.




Based on Silverlight, end-users can visualize and interact directly with an SQL Server 2012 Analysis Services (SSAS) tabular model.


Power view is a good additional tool to display reports and to give to the end-user a solution to create self-report.


For more information, click
here.
To have a set of sample to test it, click here.

SharePoint Mode

This new feature is based on a complete new architecture similar to SharePoint 2010 shared service. With this shared service, Reporting services can use a good range of SharePoint functionalities.

You have a lot of benefits like SharePoint cross-farm support for viewing reports or the SharePoint Central Administration which supports the Reporting Services SharePoint mode Configuration.

Data Alerts

A new feature for SQL Server 2012 Reporting Services called Data Alerts notifies a list of recipients about data's report changes.
Data alerts runs in the background and polls the reports for some changes.

To create and manage these new alerts, you have 3 tools:

1. Data Alert Designer


For users to create and edit data alert definitions.




For more information, click
here.

2. Data Alert Manager for Users


Users can view information, delete or change their data alerts.


3. Data Alert Manager for alerting administrators


Administrators can view information, delete or change all data alerts created by all users.


For more information, click
here.

Report Server Projects in SQL Server Data Tools for Visual Studio 2010


Add-in to Visual Studio 2010, SQL Server Data Tools (SSDT) is a development environment to modify BI Solutions.
With this tool, you can create, open and modify Report (rdl file) from version 2005, 2008 and 2008 R2.

Excel Renderer for Microsoft Excel 2003, 2007 & 2010


To enable this feature, Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint must be installed.
This extension renders a report as an Excel document compatible with Excel version 2003, 2007 and 2010
You have some limits like maximum rows/worksheet with 1048576 or Maximum columns/worksheet with 16384 but normally you have a good marge Wink

For more information, click
here.

Word Renderer for Microsoft Word 2003, 2007 & 2010


Like Excel Renderer, to enable this feature, Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint must be installed.
This extension renders a report as a Word document compatible with Word version 2003, 2007 and 2010

For more information, click
here.

Conclusion

I hope this article gives you a good vision of all new features in SSRS and all new possibilities for your business and users.

You can find all information about the new Reporting Services here on the Microsoft TechNet.

My SQL Server 2012 series will be continued soon with SSAS... Want to try SSRS 2012 hosting? Please visit our site at http://www.hostforlife.eu.