locked
Are SQL 2012 Reports compatible with VS2008 ReportViewer controls? RRS feed

  • Question

  • We have several reports built in SSRS 2008 that are viewed by an intranet application built in Visual Studio 2008 with its attendant ReportViewer control. Each of our clients have their own SQL database servers and report servers and they have our intranet application installed locally as well.  We have several new clients who want to use SQL Server 2012 with SSRS 2012. 

    Question 1: Can we simply open our old reports in SSRS 2012 and it will upgrade (if necessary) for us, or do we need to rebuild the reports in SSRS 2012 from scratch?

    Question 2: Will our web applications continue to work with SSRS 2012 reports without problems from the VS2008 ReportViewer controls, or are those ReportViewer controls incompatible with SSRS 2012 reports?

    Wednesday, June 6, 2012 7:04 PM

Answers

  • Hi Rae_P,

    Question 1: When we open an .rdl file that was created for a previous namespace in SQL Server Data Tools (SSDT) of SQL Server 2012, Report Designer automatically creates a backup file and upgrades the report to the current namespace. So, it is no need to rebuild the reports after we upgrade Reporting Services 2008 to SSRS 2012.  If a report cannot be automatically upgraded, the report is processed using the backward-compatibility mode so that it still can be open in SSRS 2008.

    Question 2: In Remote processing mode, the ReportViewer control is used as a viewer and all processing from data retrieval to report rendering is performed on the report server. Note that the ReportViewer control in Visual Studio 2008 can access a SSRS 2012 report server. So, ReportViewer control in Visual Studio 2008 can output RDL 2012 reports from a SSRS 2012 report server properly.
    Additionally, when deploying a report in SSDT, we can specify a SQL Server 2008 or SQL Server 2008 R2 report server in the project properties, the report definition is saved in a schema that is compatible with the target server.

    References:

    If you have any questions, please feel free to let me know.

    Regards,
    Mike Yin

    TechNet Subscriber Support
    If you are
    TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    • Proposed as answer by irusul Friday, June 8, 2012 6:23 AM
    • Marked as answer by Mike Yin Tuesday, June 12, 2012 8:19 AM
    Friday, June 8, 2012 3:17 AM

All replies

  • Hi Rae_P,

    Question 1: When we open an .rdl file that was created for a previous namespace in SQL Server Data Tools (SSDT) of SQL Server 2012, Report Designer automatically creates a backup file and upgrades the report to the current namespace. So, it is no need to rebuild the reports after we upgrade Reporting Services 2008 to SSRS 2012.  If a report cannot be automatically upgraded, the report is processed using the backward-compatibility mode so that it still can be open in SSRS 2008.

    Question 2: In Remote processing mode, the ReportViewer control is used as a viewer and all processing from data retrieval to report rendering is performed on the report server. Note that the ReportViewer control in Visual Studio 2008 can access a SSRS 2012 report server. So, ReportViewer control in Visual Studio 2008 can output RDL 2012 reports from a SSRS 2012 report server properly.
    Additionally, when deploying a report in SSDT, we can specify a SQL Server 2008 or SQL Server 2008 R2 report server in the project properties, the report definition is saved in a schema that is compatible with the target server.

    References:

    If you have any questions, please feel free to let me know.

    Regards,
    Mike Yin

    TechNet Subscriber Support
    If you are
    TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    • Proposed as answer by irusul Friday, June 8, 2012 6:23 AM
    • Marked as answer by Mike Yin Tuesday, June 12, 2012 8:19 AM
    Friday, June 8, 2012 3:17 AM
  • Sorry for the late response, but thank you very much for answering my questions.
    Tuesday, June 19, 2012 10:46 PM
  • Sorry for late addition but can you please provide compatibility list for remote mode:

    ReportViewer v11 (2012) is compatible with SSRS (2005, 2008, 2008 R2, 2012) ? 

    ReportViewer v10 (2010) is compatible with SSRS (2005, 2008, 2008 R2, 2012) ? 

    ReportViewer v9 (2008) is compatible with SSRS (2005, 2008, 2008 R2, 2012) ? 

    I am asking because while attempting to load a 2005 report in remote mode from ReportViewe 2012 I am getting error: "Remote report processing requires Microsoft SQL Server 2008 Reporting Services or later."

    Are they compatible or not? Or is it just a matter of changing endpoint WebService URL from http://machine/ReportServer/ReportService2005.asmx? It seems to work fine connecting to SSRS 2008 though.

    Thanks!

    Friday, May 10, 2013 1:39 PM