Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS report definition is newer than Server

I created some reports in Visual Studio 2015 with all the latest updates. However, when I try to deploy the reports I get this message:

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

The first lines of the .rdl file are set up like this:

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

Can I change the schema definition? If so, to what? I tried just changing 2016 to 2014 or 2012, but neither worked.

Is there a place I can go to see valid definitions?

like image 623
M Kenyon II Avatar asked Aug 11 '16 16:08

M Kenyon II


People also ask

How do you fix the SSRS error definition of this report is not valid?

Definition of this Report is Not Valid – Solution. There are no tricks to solving this problem. All you need to do is set the RDL to the appropriate version that's supported by your SSRS server.

How do I change RDL version?

I think quickest way is to go to the Solution Explorer window, right click on your PROJECT and go to Properties. It will open the deployment window and the very last option should be TargetServerVersion that will allow you to change the Target version.

How do I refresh data in SSRS report?

In the Report Data pane, right-click the dataset, and then click Query. Click Refresh Fields.


4 Answers

I actually ran into a similar problem where a change I needed to make resulted in an "Undocumented Error/Invalid RDL Structure" error in 2016, so I edited the RDL file so I could open it in an earlier version and make my changes. Not too hard, but you need to make a couple of tag edits.

For new reports you should probably just use an older version, but for existing reports you can do this: (I reverted to 2008)

  • Change the Report tag:
    • Remove MustUnderstand="df"
    • Change the xmlns value to "http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"
    • Delete the xmlns:df attribute.
  • Delete the entire "ReportParametersLayout" block.
  • Delete the "df" tag and its content.
  • Delete the "ReportSections" and "ReportSection" opening and closing tags (not the content).

Actually wrote some superhackish code to do this as part of a blog post, but the manual edit is simple enough.

like image 63
bitnine Avatar answered Oct 23 '22 13:10

bitnine


The settings below should be set to your sepecific version of SSRS, and then take the RDL from the \bin directory

Or, after updating the TargetServerVersion, simply use right click | deploy from the rdl.

The accepted answer is significantly more difficult/prone to error/unlikely to work across multiple versions of ssrs, and needs to be applied each time you change the rdl.

enter image description here

like image 30
Trubs Avatar answered Oct 23 '22 14:10

Trubs


I had the same issue when switching to VS2017 and installed Report Designer Version 14.2.

For me only 3 steps needed to fix the issue.

1: Set Change the xmlns to "http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition"

2: Remove ReportSections" and "ReportSection" (Only Tags).

3: Remove report ReportParametersLayout section.

The only thing you need to memorize is to point xmlns to 2008/01

Other 2 steps can be seen in the error message after you change to 2008/01 and try to run the report.

like image 12
S Nash Avatar answered Oct 23 '22 13:10

S Nash


If you are having trouble in a Visual Studo 2017 C# desktop application with LocalReport (RDLC), please see this answer:

https://stackoverflow.com/a/45149488/6732525

like image 8
Bruno Leitão Avatar answered Oct 23 '22 14:10

Bruno Leitão