CheapASPNETHostingReview.com | Best and cheap SSRS 2016 hosting. In this post I will explain about reason why you should upgrade to SQL Server 2016 Reporting Service ( SSRS). With the upcoming release of SQL Server 2016, Microsoft has blown the dust off the tried and true SSRS and injected some much-needed life. SSRS 2016 introduces a shiny new portal with a new Dashboard/Mobile report types.
1) Behind-the-scenes improvements
The background investments in SSRS 2016 have created a truly modern reporting tool. Boasting a new HTML5 renderer, Reporting Services now displays consistently and correctly across modern browsers including Edge, Chrome, Firefox and Safari. The new rendering engine no longer relies on quirks mode, used by a few older browsers, and now also supports the current version of Microsoft .NET Framework 4. Microsoft’s modern makeover of the report builder interface gives it a streamlined look. SSRS 2016 now supports high DPI (dots per inch) helping to present content in an easily readable way, reducing eye fatigue and thereby allowing for increased productivity. Printing is also easier, since SSRS replaced the former ActiveX experience with a modern, PDF-based capability that works across a matrix of supported browsers, including Microsoft Edge.
2) A superior roadmap and well-defined tool integration
Though other vendors may offer tools for reporting or data work, Microsoft continues its tradition as an end-to-end Business Intelligence leader. Microsoft offers a wide range of tools for Extract, Transform and Load (ETL), Analytics, and Reporting, from enterprise as well as self-service perspectives. Previously, the wide range of tools raised questions and confusion in users, and clear use directions weren’t officially provided. With SQL 2016, Microsoft has posted a strong reporting roadmap
The many improved abilities of the newly integrated tools include the option to pin a Reporting Services or Excel visual to a Power BI dashboard, and to store Power BI and Excel files in the new SSRS web portal.
To summarize, the path forward focuses on the four main report types:
- Paginated reports built with SQL Server Report Builder or SQL Server Data Tools
- Interactive reports built with Power BI Desktop
- Mobile reports built with Mobile Report Publisher
- Analytical reports and charts created with Excel
3) New features
There are also a ton of new features in SQL Server 2016, including:
- Subscription improvements in SSRS, including enable/disable/pause subscriptions, changing subscription owners, adding subscription descriptions, etc.
- New chart types – Tree Map and Sunburst
- Custom parameters panel to add rows and columns to change the panel layout
- PowerPoint rendering and Export
- Support of SharePoint 2016 (however, note that some of the new features might not be available in SharePoint integrated mode.
- Reporting Services web portal – an updated, modern portal that incorporates KPIs, Mobile Reports and Paginated Reports. This portal can be customized with an organization’s logo and colors by using a branding pack. You can also search for KPIs and connect them to another view to see details.
- Report embedding – embed mobile and paginated reports in other web pages, and applications, by using an iframe along with URL parameters.
The vast improvements in the latest version of SSRS haven’t gone unnoticed. Gartner has positioned Microsoft as a leader in the BI and Analytics platform.
SQL Server 2016 Release Candidate (RC2) came out Friday. Take it for a spin by downloading from the link below:
- SQL Server 2016 RC2
- Mobile Report Publisher Preview
When you’re ready to upgrade/migrate and experience the magic of SSRS 2016, have a look at the following article for best practices.