Report error on VS 2017

Dandi Box 1 Reputation point
2022-09-04T23:14:44.077+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,784 questions
{count} votes

5 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 Reputation points
    2022-09-05T03:22:41.107+00:00

    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.

    1 person found this answer helpful.

  2. AniyaTang-MSFT 12,306 Reputation points Microsoft Vendor
    2022-09-05T03:22:17.437+00:00

    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


  3. Dandi Box 1 Reputation point
    2022-09-05T08:01:21.807+00:00

    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!

    0 comments No comments

  4. Dandi Box 1 Reputation point
    2022-09-05T10:45:25.21+00:00

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


  5. Dandi Box 1 Reputation point
    2022-09-05T22:01:59.493+00:00

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

    0 comments No comments