What’s New in SQL Server 2016 Reporting Services
By Candice Bundy No Comments
Microsoft has communicated the following in their product vision for SQL Server 2016 Reporting Services:
- Originally SSRS was focused on providing printed reports to businesses. Keep in mind this was ten years ago, and businesses still need automated reporting, but it’s no longer where innovation is happening in reporting.
- Self-Service BI: consumers are demanding an interactive, user-driven reporting experience.
- Mobile computing: overall less on pc’s, more on mobile platforms. This takes mindful development for presentation due to varied mobile formats.
- Cloud-based solutions enable distributed computing for mobile excel and Power BI reports.
- On-premises solutions which allow local access via SharePoint and Reporting Services Web Portal.
- Datazen is being seamlessly integrated for mobile reporting.
Here’s a list of what’s New in SQL Server 2016 Reporting Services:
- Push to making reporting services the modern, mobile solution
- Upgraded paginated reports with new tools and features
- Modern chart and gauge styles
- Treemap and sunburst charts
- Updated Report Builder look-and-feel
- Visual Studio 2015 support
- Plugin-free printing
- Customization parameter layout – now available in the design time experience
- Position parameters across more than two columns
- Choose the position of each parameter
- Create space between groups of parameters
- Export to PowerPoint
- Generate slides including all report content in seconds
- Move and resize individual objects
- Export manually, on a scheduled basis, or generate programmatically
- Pin report items to Power BI dashboards
- Monitor the most important metrics and trends in one place
- Pin charts, gauges, maps, and images as tiles to Power BI dashboards
- Drill through to source reports
- Refresh tiles on a schedule
- Create interactive mobile reports
- Drag-and-drop to create beautiful, interactive data visualizations
- Prototype in minutes with simulated data
- Access enterprise data sources by connecting to Reporting Services
- Customize layouts for different form factors (mobile-friendly)
- Consume mobile reports
- One mobile app for Power BI and Reporting Services mobile reports
- Native mobile experience optimized for touch
- Keep data up-to-date with real-time query or scheduled data refresh
- Interact with mobile reports even when disconnected
- New, modern web portal for reports
- Built on HTML5 technology
- Access KPIs on both types of reports in one web portal
- Designed for modern browsers
- Expanding the platform to handling mobile reporting
- New web portal that consumes both paginated and mobile reports using all modern browsers
We’re excited to see the focus on mobile reporting, as this is a key component our customers are focusing on!