CODEWITHSUNDEEP
sql-serverreporting-servicesreportviewerssrs-2016
Joe Starnes
Joe Starnes

Reputation: 491

SSRS 2016 Report Viewer Control

We are looking at installing SSRS 2016. We currently use ReportViewer Control 11 (2012). Do we need to upgrade to ReportViewer Control 12 (2015) in order for us to view reports?

I'm assuming there isn't any 2016 version yet.

Just want to make sure all is possible if we install 2016 version of SSRS.

Upvotes: 7

Views: 10560

Answers (3)

Larry Smithmier
Larry Smithmier

Reputation: 2731

The 2016 version of the Report Viewer control is now available for WinForms and WebForms. (27.07.2017) The NuGet package is available at Microsoft.ReportingServices.ReportViewerControl.WebForms and Microsoft.ReportingServices.ReportViewerControl.WinForms but the MVC version is still pending.

Upvotes: 2

Brad
Brad

Reputation: 167

Microsoft has released an early preview of the Report Viewer 13 controls on nuget. I have tested it out and found it to be working just as well as the viewer directly on the report server.

The only issue I have ran into is that hidden parameters now seem to leave a blank table cell in the toolbar rather than shifting the non-hidden parameters over.

https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms.Preview/

Using the report viewer control:

http://go.microsoft.com/fwlink/?LinkId=827676

Upvotes: 3

Chris Schaller
Chris Schaller

Reputation: 16554

SSRS 2016 Report Designer uses a new 2016 schema definition for the rdls that is NOT supported by the v12 control:

http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition

So if you Upgrade your SSRS to 2016, and you have upgraded your designer tools and you are using the report viewer control in your own web app (which you must be or you wouldn't have asked right) Then you will have to use the v13 report viewer.

If your RDLs are not edited with the latest designer tools, the v12 report viewer should still be able to render them, though I have not tested this scenario against the latest CTP

The v12 report viewer is backwards compatible with 2005, 2008, 2010 and of course the 2012 schema definitions (which is used by the 2014/2015 report designers).

So if your team has upgraded to VS 2015 Update 3, with the latest SQL Server Data Tools, then you will start to see 2016 report definitions popping up as they get edited.

previous versions of SQL Data Tools would only upgrade the RDL definition when you used one of the new features, this new version seems to upgrade them regardless

There is no 'official' client runtime download for the v13 report viewer yet, you will have to extract the necessary dlls from the GAC from the server with SSRS 2016 running on it, or from a development machine with the latest Data Tools installed. If you run into issues have a look at the ReportViewer.aspx file in the SSRS 2016 Web App Folder for the latest syntax changes.

Upvotes: 3

Related Questions