Is there a new Report Viewer Runtime for SQL 2016?

advertisements

Is there a new Report Viewer runtime for SQL 2016? I get the new report viewer UI when I log into the SSRS Reports manager, but, if I embed those reports in a website, it requires the Report Viewer redistributable, and the most recent one I can find is from 2015, which I assume will not have the new UI.

Thanks!

Ryan


No, there isn't, at least not yet.
The ReportViewer installed by SQL-Server 2016 is v12, which is the 2015 Viewer.

Also, it seems SSRS 2016 uses a RS:ReportHost tag, wheras < 2016 used to use the rs:ReportViewer tag.


Edit:
But now you can download the preview here:
https://www.nuget.org/api/v2/package/Microsoft.ReportingServices.ReportViewerControl.WebForms.Preview/130.1700.305

Rename

microsoft.reportingservices.reportviewercontrol
.webforms.preview.130.1700.305.nupkg

to

microsoft.reportingservices.reportviewercontrol
.webforms.preview.130.1700.305.nupkg.zip

and then unzip it.
It still is using .NET Framework 4.0.

I got it working, here:
https://github.com/ststeiger/ReportViewerWrapper/tree/master/Embedded2016
Just in the nick of time, had to fix a nasty bug with WordOpenXML export.
In versions of ReportViewer < 2016, you can't print a Word 2007+ (WordOpenXML) document when in landscape-format).
Switching to ReportViewer 2016 Preview solved this.

There appears to be a bug in ReportViewer, when you export to word.
Vertical alignment is not center by default, in Visual Studio it is (old bug).
And merging the last row of a table in a word-document will result in a garbage-layout - when pageformat = landscape (new bug).

If you put this formula into the footer

=System.Convert.ToString(Globals!PageNumber) + "/" + System.Convert.ToString(Globals!TotalPages)

you always get 1/1 in Word.
If you use

=Globals!PageNumber & "/" & Globals!TotalPages

then it works correctly... (old bug)