when you try to upload RDL (report definition language) file into your SSRS reports ,you will hit with 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) Get Online Help”
Why does this error occur ?
If the RDL file report created using the X (in this case 2016) version of reporting tool that is higher than your SQL reporting services installed (<2016) ,then you will have this issue.
In my case, am running on SQL server 2014 with reporting services installed on my SCCM server and trying to upload SCCM report that was created on version 2016.
How do we make this report work on older version of reporting ? You need to make 2 changes in to the RDL file to get it working.
1. Open the RDL file using notepad or other editing tools ,you will find something like below in the beginning of the code.
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 below ,remove the whole block and save the report.
Now try to upload the RDL file into the reporting service ,change the data source and run the report.
change the SQL version on the RDL file and remove the ReportParametersLayout to get the report working.
Thank you very much for this very clear and simple instruction!!! It solved my problems.
Thank You so much man, been struggling with this for 2 days.
I just did it! It worked!!! Thank you – thank you – thank you!!!
I am using visual studio 2019 and sql server 2016. After making above changes, RDLC report now shows the new error -"A data source instance has not been supplied for the data source... message. If I go back and add back data source again, version of report is now changed back 2016. So I am cycling between same 2 errors. Any suggestions much appreciated
after you make the changes, did you change the data source to the correct one?
Thank you so much for your helpful work.
Pingback: Error while uploading a report – oraerr.com
Thank You so much Eswar for this resolution!!
Glad ,it helped!
Thank you so much, is working