Post reply

SSRS Report version compatibility issue with 2016 to 2012

  • August 10, 2018 at 10:04 am

    #375194

    Hi Every one,
    I hope, you are doing good. 
    I am facing a challenges in SQL Server Reporting Services when uploading 2016 version reports in 2012 server and am getting below error.  So, Could you please help me how to proceed? 

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

     Thanks
    Kanagarajan S.

  • August 10, 2018 at 8:27 pm

    #2001335

    You can't upload/serve SSRS 2016 reports on SSRS 2012.

  • August 11, 2018 at 2:19 am

    #2001342

    Thanks for your response.

    How to degrade reports RDL from 2016 to 2012 servers? Is there any option to migrate from higher to lower version.

    Thanks
    Kanagarajan S.

  • August 13, 2018 at 7:40 am

    #2001470

    manavairajan - Saturday, August 11, 2018 2:19 AM

    Thanks for your response.

    How to degrade reports RDL from 2016 to 2012 servers? Is there any option to migrate from higher to lower version.

    Thanks
    Kanagarajan S.

    The only possible way to do this is to use Visual Studio and have a reporting services "project" into which these reports are added (the .RDL files).   Once you have the project, you change the project properties to deploy to the option that includes SQL 2012.   Having made that project properties change, you can then "BUILD" each report, and look in the ..\bin\Debug folder (the default folder relative to the project) to find the RDL files you can actually use.   The ones in the main project folder will be based on the version of Visual Studio that you use.   Be sure to  use a version of Visual Studio capable of reading the 2016-formatted RDL files.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply