none
Reports created in 2008R2 BIDS -- have to be used on BOTH SQL Server 2008 R2 AND SQL Server 2012

    Question

  • We have about 150 reports created in BIDS 2008 R2. These reports also reference assemblies; have shared data sources and shared datasets. We want to keep one copy of the reports and deploy to both SQL Server 2008 R2 and SQL Server 2012 environments. We found that SQL server 2012 does not always like a report created in BIDS and displays erratic behavior until we open and deploy from SSDT (Data Tools 2012). Is our best option to open, save and deploy all the rdls from SSDT to both SQL Server 2008 and SQL Server 2012? Do we need to do this to all the rdls created in BIDS 2008 R2? Thanks!

    Laura

    Tuesday, May 14, 2013 11:03 PM

Answers

  • Hi Laura,

    Because the SQL Server Reporting Services (SSRS) back compatibility, we can deploy SSRS 2012 reports to SSRS 2008 R2 Report Server without any problems. However there may be some erratic behaviors when you deploy a SSRS 2008 R2 report to SSRS 2012 server. So as per my understanding, the best option is open those projects in SSDT, then it will upgrade to SSRS 2012 instance automatically, and then deploy it to both SQL Server 2008 and SQL Server 2012 from SSDT.

    Hope this helps.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by Laura921 Friday, May 17, 2013 3:33 PM
    Thursday, May 16, 2013 8:39 AM
  • Hi Laura,

    The short answer for your questions is YES. You can deploy them to SSRS 2008 R2 server no matter you recreate new report or open an existing RDL  in SSDT.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by Laura921 Friday, May 17, 2013 3:33 PM
    Friday, May 17, 2013 1:26 AM

All replies

  • Hi Laura,

    Because the SQL Server Reporting Services (SSRS) back compatibility, we can deploy SSRS 2012 reports to SSRS 2008 R2 Report Server without any problems. However there may be some erratic behaviors when you deploy a SSRS 2008 R2 report to SSRS 2012 server. So as per my understanding, the best option is open those projects in SSDT, then it will upgrade to SSRS 2012 instance automatically, and then deploy it to both SQL Server 2008 and SQL Server 2012 from SSDT.

    Hope this helps.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by Laura921 Friday, May 17, 2013 3:33 PM
    Thursday, May 16, 2013 8:39 AM
  • Hi Charlie,

    Thanks for the repsonse.

    So, if I create a new report using SSDT am I able to deploy it to SSRS 2008 R2?

    If I take an existing rdl created in BIDS and update it in SSDT, am I able to deploy it to SSRS 2008 R2?

    --Laura


    Laura

    Thursday, May 16, 2013 10:44 PM
  • Hi Laura,

    The short answer for your questions is YES. You can deploy them to SSRS 2008 R2 server no matter you recreate new report or open an existing RDL  in SSDT.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by Laura921 Friday, May 17, 2013 3:33 PM
    Friday, May 17, 2013 1:26 AM