Report error on VS 2017

Question

Report error, I opened an old project with Visual Studio 2017 and when I compile I get this error

Severity Code Description Project File Line Suppression State

Error The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition' which cannot be upgraded. C:\Users\Administrator\Desktop\App\App.Web\Reports\Report_Libretto.rdlc 1

Can you kindly help me?

Answer 1

Hi @Dandi Box ,
This error happens when the schema of the report has been upgraded to the latest and your trying to publish it to an older server, You can set the target server version in the deployment properties to help with this however you cannot use newer features in your report that are not supported on older servers.

Or Change the rdl schema from 2016 to 2010 with the following settings in the XML file:
(1) Change from:

 <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">  

To:

 <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">  

(2) Delete <df:DefaultFontFamily>Segoe UI</df:DefaultFontFamily>

(3) Remove the "ReportParametersLayout" block.
Until no error is displayed and it can be previewed correctly in Visual Studio. You could refer to: Downgrade SSRS from 2016 to 2008.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Dandi Box
You can try to create a new report, click View Code to copy the name space of the new report, then Update the XML on your imported report.
For more details, you can refer to this link: report-definition-has-an-invalid-target-namespace.
Best regards,
Aniya

Answer 3

Doesn't works, in my old reports I had 2005, here what I tried to do

Googling I have already tried to change string value from 2016 to 2005 (what my RDLC file had before ... 2005) but then during the compilation phase I get other (new) errors because the RDLC file in the meantime has been transformed into the new version and therefore some elements of the XML are not recognized.
Can anyone help me manage this report, and fill it out without problem? I'd like to edit and customize this old reports files.
When I try to open with VS 2017 asks me to update... if I update I can edit file and show report layout content, but when I compile I get previous error posted

Ahen I change path to 2005 (as in other reports)

Severity Code Description Project File Line Suppression State
Error The report definition is not valid. Details: The element 'Report' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has invalid child element 'ReportSections' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'. List of possible elements expected: 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Description http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Author http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:AutoRefresh http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:DataSources http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:DataSets http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Body http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:ReportParameters http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Code http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Width http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:PageHeader http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:PageFooter http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:PageHeight http://schemas....

Thanks for help me!

Answer 4

Doesn't works, in my old reports I had 2005, here what I tried to do

Googling I have already tried to change string value from 2016 to 2005 (what my RDLC file had before ... 2005) but then during the compilation phase I get other (new) errors because the RDLC file in the meantime has been transformed into the new version and therefore some elements of the XML are not recognized.
Can anyone help me manage this report, and fill it out without problem? I'd like to edit and customize this old reports files.
When I try to open with VS 2017 asks me to update... if I update I can edit file and show report layout content, but when I compile I get previous error posted

Ahen I change path to 2005 (as in other reports)

Severity Code Description Project File Line Suppression State
Error The report definition is not valid. Details: The element 'Report' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has invalid child element 'ReportSections' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'. List of possible elements expected: 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Description http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Author http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:AutoRefresh http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:DataSources http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:DataSets http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Body http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:ReportParameters http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Code http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:Width http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:PageHeader http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:PageFooter http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:PageHeight http://schemas....

Answer 5

Please help me!! I don't know how to resolve this issue!!!