Problems in Report Viewer in Visual Studio 2017

Navigation
1

until recently I was working with VS2015 and I could create reports with report viewer normally and everything worked normally, now I started working with Visual Studio 2017 and I have problems with the reports, I explain:

In case of having a report without parameters or data sources everything works normally, but this kind of reports I think they do not help anyone. Here's the point, when I add even a simple string parameter, it simply jumps an exception as shown in the following image:

If someone has the same problem or some idea of how to solve it, I would greatly appreciate it, as many do in my place.

I thank you in advance, cordial greetings to all.

    
asked by RSillerico 21.09.2017 в 04:14
source

2 answers

0

I think you should "go back" to create the report or open it in the new version of the visual studio, that's normal when you change the version. The version of Report Viewer for VS 2015 is 13 and I think it is 14, it is incompatible in the xml file that the ReportViewer generates.

    
answered by 29.09.2017 в 20:10
0

If you can open the report you will see that it has the namespaces (xmlns) that has this 

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">....

For this type of reports it is convenient for you to have the latest ReportViewer.

For that you have to download it from nuget, for example for webforms

Do you use VS2017 also to assemble your reports? I would recommend Microsoft® SQL Server® 2016 Report Builder . But it must be that it is a custom of several years.

The last update of SSDT (SQL Server Data Tools for Visual Studio) brings the part of Reporting, in addition to database projects, analysis services integration services. If you want to work within Visual Studio 2017 you will have to install it

  • (Download and install SQL Server Data Tools (SSDT) for Visual Studio) [ link

PS: When you install SSDT it asks you to install in a new VS instance or in the one you have.

I hope it will help or guide you

    
answered by 15.09.2018 в 15:55
Take the result of a list and print it in a JTextArea Query Transact Sql - SubSelect