SQL Server 2016 – Reporting Services

With the release of SQL 2016, there are new applications that are now available to help in building reports. Once you have reporting services available, you can download them from the site.

Clicking the link for Mobile Report Publisher will take you to this page: https://www.microsoft.com/en-us/download/details.aspx?id=50400, clicking the Report Builder will take you here: https://www.microsoft.com/en-us/download/details.aspx?id=52674

Once you have them downloaded you can run through the base installations by following the wizards.

In order to install the Mobile Report Publisher you need to install the C++ runtime from here: https://www.microsoft.com/en-us/download/details.aspx?id=30679

Once they have bene installed you should have the following applications.

Clicking the Report Builder now loads a fully-fledged application for creating the reports.

Once the type of report has been selected you can use ribbon bar.

Data Sources can either be connected directly as new, or use data connections that already exist. It is nice to see that a “SharePoint List” is an option for data.

Once you have a report built you can then publish report parts, which will include all of the dependencies, as well as save the entire report.

If you want to create a mobile report then when launching it you can see it is faster loading and lightweight rebrand of the Datazen Publisher. Creating the Mobile Reports is easy as dragging and dropping, then configuring as needed.

Saving the reports is as simple as choosing where to save, if it is server then you specific the reporting services server name: {servername}/reports

Once we you have saved reports, when accessing the reporting services site you should see them listed, along with report parts or regular reports.

Of course the rendering is now done using a HTML 5 engine so they work and look as expected in the browser.

All in all, the new Reporting Services 2016 is a great update to the old reporting services and Datazen, allowing you to create the reports and dashboards that a business needs easily.

Liam Cleary

I work as an Associate Director for Protiviti in Virginia. My main focus is to ensure that SharePoint can either natively or with minimal customization meet the business requirement securely. I am currently a SharePoint MVP focused on Architecture but also cross the boundary into Development and Security. I am often found at user groups, conferences speaking, offering advice, spending time in the community, teaching my kids how to code, raspberry PI programming, hacking the planet and sometimes building Lego robots.

You may also like...