3

Previously, the web application is using VS2010 to develop SSRS report. but when I want to upload the rdl file to server (Windows Server 2008) ..currently, I'm using VS2015 to develop the new report. it cause the following error.

The report definition is not valid or supported by this version of Reporting Services. This could be the result of publishing a report definition of a later version of Reporting Services, or that the report definition contains XML that is not well-formed or the XML is not valid based on the Report Definition schema. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition)

Other developer suggest that, change the path to target 2010 version, then will solve the problem, but that is not the way to solve it.

NOTE: The URL provided in Error is empty.

and the reporting server is Microsoft SQL Server Reporting Services Version 10.50.6000.34

then which version that i should choose for?

-SQL 2008 -SQL 2008 R2, SQL 2012, SQL 2014 -SQL 2016+ (new in VS 2015 with latest SSDT-BI)??

Cheah Eng Teong
  • 39
  • 1
  • 2
  • 12
  • What version of reporting services is running on the server? – BishNaboB Jan 23 '17 at 10:18
  • You could try changing the TargetServerVersion in the project properties to see if that helps. Not really sure it will if you are uploading RDL manually. – R. Richards Jan 23 '17 at 13:39
  • Possible duplicate of [SSRS 2014 report deploy issue](http://stackoverflow.com/questions/39188874/ssrs-2014-report-deploy-issue) – SMM Jan 23 '17 at 15:41
  • @BishNaboB version 2010 How to go to changing the TargetServerVersion in VS2015? I already update the details..what i missing installation in SQL Server 2008 R2? – Cheah Eng Teong Jan 24 '17 at 01:54
  • Have a look at my answer under the duplicate and see if that helps. – SMM Jan 24 '17 at 13:32
  • @SMM it does not help at all, once i click on Build, the RDL become 2016 version still caused can't upload to the server. – Cheah Eng Teong Jan 25 '17 at 02:39
  • The RDLs in the project folder will be 2016 no matter what you do. They will automatically upgrade every time you open them. However as long as you set you target to the appropriate SQL version the RDLs in the \bin folder will be the correct version. – SMM Jan 25 '17 at 04:03

2 Answers2

0

The simple solution is Make back up of your .sln file Open your VS 2010 .sln in notepad.

It should look something like this: Microsoft Visual Studio Solution File, Format Version 11.00

Visual Studio 2010 Project("{FAE04EC0-3 ......

Change the Version 11.0 to Version 10.0 and the Visual Studio 2010 to 2008

It should look something like this: Microsoft Visual Studio Solution File, Format Version 10.00

Visual Studio 2008 Project("{FAE04EC0-3 .....

From: How to downgrade from Visual Studio 2012 project to Visual Studio 2008

Community
  • 1
  • 1
Cheah Eng Teong
  • 39
  • 1
  • 2
  • 12
0

Check remarks answer on this post for alternative solution : [SSRS report definition is newer than Server

because i've got same eror on Visual Studio 2017 and only this solution works for me.

kho dir
  • 125
  • 4