Error while uploading a report

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)”

Solutions/Answers:

Solution 1:

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.

Solution 2:

Your report is targeting SQL server 2016

Solution 3:

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.

Related:  Why underline is usually used in the sql table names rather than camel case [closed]

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

Solution 4:

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.

Solution 5:

Although the question is answered but this solution might help for the new visits.

In Visual Studio, go to tools -> Extensions and updates -> updates -> Update Reporting services.

After you close Visual Studio, it installs an VSiX installer .

Related:  Return the count of rows grouped by week MySQL

The problem was solved for me. Hope this helps.

Solution 6:

I got the answer from link “https://www.sqlskills.com/blogs/tim/issue-publishing-to-ssrs-2012-with-ssdt-2015/

Issue publishing to SSRS 2012 with SSDT 2015
By: Tim Radney
Posted on: January 22, 2016 2:58 pm
I recently was helping a client who was trying to use SQL Server Data Tools 2015 to update and generate reports that would be deployed to SQL Server Reporting Services 2012. When trying to deploy the report, the client would get the following error:

“[rsInvalidReportDefinition] 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.”

I knew that SSDT 2015 should be backwards compatible and able to work with multiple versions of SQL Server products, so I had to do a little research to figure out what exactly needed to be changed in order to publish a report to SSRS 2012.

In my lab, I created a new project named GetDatabases. This project was a basic report that would get query a system table. The first thing I tried to change in the project was the TargetServerVersion located under the project properties.

I updated the TargetServerVersion to “SQL Server 2008 R2, 2012, or 2014”, the default in was “SQL Server 2016”. I also updated the TargetServerURL to my development server running SSRS 2012. I made these changes to both the release and debug configuration options.

Related:  Can I get SQL injection attack from SELECT statement?

After making these changes, I was still unable to deploy the report. After a bit more research, I found a location to change the default deployment server version of the Business Intelligence Designer. This is located under ‘Tools and then Options’. The default was set to version 13.0, once I changed the version to 11.0 to match the server I was deploying to, I was able to successfully deploy my report to SSRS 2012.

enter image description here

Solution 7:

I right clicked on my report and then clicked publish report1.rdlc which worked for me.

Solution 8:

None of the proposed solutions worked for me, while I correctly have set the TargetServerVersion in the project properties. Note that I don’t think that manually editing the .rdl file is a solution that is sustainable.

I do have a strange solution:
In the IDE (Visual Studio 2019 in my case) change the Solution Configuration from Debug to DebugLocal. Now change the TargetServerVersion to any version you’d like, rebuild the report project and inspect the .rdl file, with any text editor, in the bin\DebugLocal folder.

You’ll notice now that the namespaces DO react on every change to TargetServerVersion + rebuild.

Note: this only seems to work when the Solution Configuration has been set to DebugLocal, not for Debug or Release!!

References