Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Error while uploading a report

I have create a report using visual studio 2015 with SSDT Tools installed from the following link

https://msdn.microsoft.com/en-us/mt186501

The database is on SQL Server 2014. The reports work on my machine however when I try to upload a report on customers machine(Which has SQL Server 2014 and not visual studio). I get the following error

"The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition)"

like image 459
Abe Avatar asked Mar 10 '16 16:03

Abe


4 Answers

If you have the solution > properties > TargetServerVersion set to SQL Server 2008 R2, 2012 or 2014 and then upload the RDL from the bin folder instead of the project folder, it should work. I was getting the same error and that solved it.

like image 196
Andrew Failor Avatar answered Nov 04 '22 05:11

Andrew Failor


Your report is targeting SQL server 2016

like image 31
Ed Elliott Avatar answered Nov 04 '22 07:11

Ed Elliott


That one worked for me: getting SSRS version 2016 error, need to edit rdlc report. For detailed step visit this link: http://eskonr.com/2018/06/configmgr-ssrs-failed-to-upload-rdl-with-error-code-definition-of-this-report-is-not-valid-or-supported-by-this-version-of-reporting-services/

Changes:

  1. Search 2016, change the version from 2016 to 2010 .
  2. Search for "ReportParametersLayout" in file and remove the whole block (This code is created on 2016 version of visual studio).

As shown above, remove the whole block and save the report.

like image 5
Khushboo Tahir Avatar answered Nov 04 '22 06:11

Khushboo Tahir


If you are used Visual studio 2017

Update: Microsoft released a document on April-18, 2017 describing how to configure and use the reporting tool in Visual Studio 2017.

Visual Studio 2017 does not have the ReportViewer tool installed by default in the ToolBox. Installing the extension Microsoft Rdlc Report Designer for Visual Studio and then adding that to the ToolBox results in a non-visual component that appears below the form.

Microsoft Support had told me this is a bug, but as of April 21, 2017 it is "working as designed".

The following steps need to be followed for each project that requires ReportViewer.

If you have ReportViewer in the Toolbox, remove it. Highlight, right-click and delete. You will have to have a project with a form open to do this. If you have the Microsoft Rdlc Report Designer for Visual Studio extension installed, uninstall it. Close your solution and restart Visual Studio. This is a crucial step, errors will occur if VS is not restarted when switching between solutions. Open your solution. Open the NuGet Package Manager Console (Tools/NuGet Package Manager/Package Manager Console) At the PM> prompt enter this command, case matters.

Install-Package Microsoft.ReportingServices.ReportViewerControl.WinForms

You should see text describing the installation of the package.

I hope its working

like image 3
Shailesh Prajapati Avatar answered Nov 04 '22 07:11

Shailesh Prajapati