Pages

SQL Server 2016 Reporting Services (SSRS): What Is New?



What is new in SQL Server 2016 Reporting Services? According to the Microsoft white paper on “Deeper Insights Across Data”:

  • Now supports all major browser: Internet Explorer, Chrome, Firefox, and Safari
  • Power BI Integration
  • Report templates and themes similar to Power BI
  • Customize Report Themes using CSS
  • Improved report parameter UI
  • Now supports mobile BI and data visualization on Windows, iOS, and Android devices
  • From Other Sources
    • Report Builder will live on (click here)
    • New Chart Types
    • Responsive Design

Complete white paper paragraphs:

Report UX enhancements

SQL Server 2016 makes several enhancements to Reporting Services, especially in the areas of the user experience and mobile reporting. SSRS now supports report consumption from all major modern browsers, including the latest versions of Internet Explorer, Chrome, Firefox, and Safari.

SSRS report styles have also been enhanced with new report templates and themes that are similar to those in Power BI. You can also customize report themes using CSS, allowing you to easily create and apply a company branding for your reports.
SSRS has improved the UI for working with report parameters. For example, you can now display hierarchical parameters as a tree. You also have more control over the layout of parameter panel, and parameter text fields now support autocomplete and search.

Additionally, there are more data sources available due to the integration with Power Query. And Power BI integration means you can view reports with on-premises data in the Power BI service on the cloud.

Mobile BI

SQL Server 2016 now supports mobile business intelligence and data visualization on Windows, iOS, and Android devices (Figure 12). This allows users to visualize and interact with data on their mobile devices, using the native mobile apps available at no charge at the respective app stores. You can use these tools to connect to enterprise data sources, integrate with Active Directory for user authentication, deliver live data updates to mobile devices, and personalize data queries for each user.

Since Skype for Business Server 2015 Monitoring Reports are based on SQL Server, by implication these enhancements should make their way to Skype for Business Server monitoring report eventually.

http://sqlturbo.com/sql-server-2016-new-features/
http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/27/sql-server-2016-first-public-preview-now-available.aspx

Read the SQL Server 2016 Deeper Insights Across Data technical white paper

2 comments:

  1. Could somebody tell me if 2016 SSRS has the ability to show multi valued parameters hierarchically (i.e. nested like a tree view). This always worked for OLAP parameters but for straight 2d datasources, no. I want the ability to avoid cascading parameters and expand and collapse available values in a normal parameter. Is it possible yet? The above suggests that it is but I can't see any microsoft doco on it.

    ReplyDelete
  2. Possible to secure SSRS 2016 with SAML 2.0? Any chance we will ever see a native SharePoint Online SSRS 2016 Web part? SSRS reports inside SharePoint Online (not just On Premise Claims) under the same authentication would be brilliant.

    ReplyDelete

Note: Only a member of this blog may post a comment.