Blog - comments

When I studied Oracle New Feature Guide "Media Failure: PDB SYSTEM Data File" , I was surprised tha...
Hayat Khan

Really a nice article to study.

Thanks,

Amol Bhoite

ana 100 goid

mokok

ana 100 gold

mokok

Bonjour,

Tout d'abord merci pour cet article. J'aimerai savoir si ACFS est gratuit ?

Chris

Chris
Blog Stephane Haby SQL Server 2012: new features for Reporting Services (SSRS)

dbi services Blog

Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server, Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

SQL Server 2012: new features for Reporting Services (SSRS)

I have decided to take some time in this cold month of February to continue this small series. This time, I'm going to speak about Reporting Services (SSRS) and some new features. Like my other article "SQL Server 2012: New features on Integration Services (SSIS)", this article presents a summary of new features and enhancements for SQL 2012 Reporting Services.

The most important new feature is Power View (codename Crescent).

Power View

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

IC541104

Based on Silverlight, end-users can visualize and interact directly with an SQL Server 2012 Analysis Services (SSAS) tabular model.
I will explain what news on SSAS is in the next article Laughing

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:

 

  • Data Alert Designer

For users to create and edit data alert definitions.

dataalertdisigner

For more information, click here.

  • Data Alert Manager for users

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

  • 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...

Rate this blog entry:
2

Stéphane Haby is Delivery Manager and Senior Consultant at dbi Services. He has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. Stéphane Haby is Microsoft Certified Solutions Associate MCSA) for SQL Server 2012 as well as Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008. He is also ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals & Pharmaceuticals, Banking / Financial Services, and many other industries.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Friday, 18 April 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)
NewsOfficesContact

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter