WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 479 reviews for our classroom and online training
An analysis of the main new features in SQL Server Reporting Services 2016
Part five of a six-part series of blogs

Microsoft have put a lot of effort into SSRS 2016, including completely rewriting Report Manager (it's now called Web Portal) and creating separate software for publishing reports to mobiles. There are lots of new features to contemplate!

  1. What's new in Reporting Services 2016 (SSRS 2016)
  2. SSRS 2016 - the basic user interface for creating reports
  3. Report Manager becomes Reporting Services Web Portal
  4. Mobile Report Publisher in Reporting Services 2016
  5. Report Builder 2016 (Report Builder for SSRS 2016) (this blog)
  6. Other new features in Reporting Services 2016

This is part of a wide-ranging blog explaining the new features in every part of SQL Server 2016.

Posted by Andy Brown on 11 July 2016

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Report Builder 2016 (Report Builder for SSRS 2016)

As far as I can tell there is no Report Builder 4.0; instead Microsoft have rebranded it as Microsoft SQL Server 2016 Report Builder.  They've also included a small number of changes.

Downloading Report Builder works for any browser

You can download Report Builder from the new SSRS web portal:

Download Report Builder

You could do this before, but the difference is that the download no longer uses ClickOnce, and so is browser independent.


New look-and-feel

Microsoft claim that Report Builder has a new look to it:

New look UI

To me this looks very much like the old Report Builder, but with the colour sucked out of it!


New parameters pane

You can now position parameters using this pane (see the part of this blog on the SSRS basic user interface for more details on this):

New parameters pane

The parameters pane in Report Builder (it's also there in Reporting Services).


Still no expression intellisense

It's really disappointing to see that the intellisense in SSRS expressions STILL doesn't carry through to report builder:

Intellisense lack

You still can't see, for example, what arguments a function takes!


More dots per inch

Apparently there is much better resolution in Report Builder:

Report builder report

It's hard to see whether the increased number of dots per inch makes a difference from a screen shot ...

I'm really disappointed that Report Builder doesn't include expression intellisense, and think that it's still far more sensible to develop reports in Reporting Services than in Report Builder.

This blog has 0 threads Add post