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

Liam began his career as a Trainer of all things computer-related. He quickly realized that programming, breaking, and hacking was a lot more fun. He spent the next few years working within core infrastructure and security services until he found SharePoint. He is the founder and owner of SharePlicity, a consulting company that focuses on all areas of Technology. His role within SharePlicity is to help organizations implement technology that will enhance internal and external collaboration, document and records management, automate business processes, and of course security controls and protection. He is also a Microsoft MVP focusing on Architecture but also crosses the boundary into Development. He is also a Microsoft Certified Trainer (MCT). His specialty over the past few years has been security in SharePoint and its surrounding platforms. He can often be found at user groups or conferences speaking, offering advice, spending time in the community, teaching his kids how to code, raspberry PI programming, hacking the planet or building Lego robots.

You may also like...