locked
Reporting Service 2005 to 2014 migration. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    We are in the middle of migrating our SSRS 2005 server to SSRS 2014. So far all the reports are working except our barcode reports. When we try and upload the barcode reports we get the following message:

    "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: Deserialization failed: The element 'Style' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' has invalid child element 'Border' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'. List of possible elements expected: 'BorderColor, BorderStyle, BorderWidth, BackgroundColor, BackgroundGradientType, BackgroundGradientEndColor, BackgroundImage, FontStyle, FontFamily, FontSize, FontWeight, Format, TextDecoration, TextAlign, VerticalAlign, Color, PaddingLeft, PaddingRight, PaddingTop, PaddingBottom, LineHeight, Direction, WritingMode, Language, UnicodeBiDi, Calendar, NumeralLanguage, NumeralVariant' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' as well as any element in namespace '##other'. Line 664, position 26. (rsInvalidReportDefinition)."

    If I change

    http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition

    With

    http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition

    We get the following message:

    "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 formed or not valid based on Reporting Services schemas. Details: The report definition has an invalid target namespace " which cannot be upgraded. (rsInvalidReportDefinition)"

    Here is an example of one of our report files: (too many characters to upload here so I've linked it to my DropBox) https://www.dropbox.com/s/z5eb9m9cpw6ivrj/Item%20Barcodes%20%28Subassembly%29%20-%20Neodynamic.rdl?dl=0

    What needs to be changed for these reports to run on 2014?



    • Edited by Kelvin.uk Friday, February 6, 2015 9:10 AM
    Friday, February 6, 2015 9:02 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Kelvin.uk,

    Based on my understanding, you are migrating the content of Report Server 2005 to Report Server 2014, but the barcode reports can’t be uploaded to report server 2014 and error is thrown out.

    In Reporting Services, upgrading a report definition in SQL Server Data Tools is the only way to upgrade the .rdl file. In your scenario, since you are migrating the reports to a new environment with a higher Reporting Services version installed, and some .NET components are referenced when creating the barcode reports, you should upgrade reports definition, then deploy them to report server.

    Reference:
    Upgrade Reports

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu

    Qiuyun Yu
    TechNet Community Support


    Monday, February 9, 2015 7:07 AM