Trying to upload a newer version of SSRS RDL file to a older reporting server…
Uploading SSRS 2019 to SSRS 2012 server.
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) Get Online Help
Workaround:
For new reports you should probably just use an older version, but for existing reports you can do this: (I reverted to 2008 R2)
- Change the Report tag.
- Delete the entire “ReportParametersLayout” block.
Replace
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
with
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">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) Get Online Help
Fix: Replace the report tag header.
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 element ‘Report’ in namespace ‘http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition’ has invalid child element ‘ReportParametersLayout’ in namespace ‘http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition’. List of possible elements expected: ‘Description, Author, AutoRefresh, InitialPageName, DataSources, DataSets, ReportParameters, Code, EmbeddedImages, Language, CodeModules, Classes, CustomProperties, Variables, DeferVariableEvaluation, ConsumeContainerWhitespace, DataTransform, DataSchema, DataElementName, DataElementStyle, ReportSections’ in namespace ‘http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition’ as well as any element in namespace ‘##other’. (rsInvalidReportDefinition) Get Online Help
Fix: Delete the entire “ReportParametersLayout” and “GridLayoutDefinition” block.
Sources:
https://stackoverflow.com/questions/38902037/ssrs-report-definition-is-newer-than-server
Comments