none
Visual Studio 2010 and SSRS 2005 RRS feed

  • Question

  • We are upgrading our Web development to VS 2010 and are now at the point of integrating our reports into it.

    All reports were built us BIDS 2005...   We cannot afford to upgrade to SQL sever 2008 or 2010 at this moment due to a large number of systems currently running on 2005.

    How can I get the following code that previously worked using VS 2005 to now work in VS 2010?

     

    Dim ReportViewer As New ReportViewer

    ReportViewer.ServerReport.ReportServerUrl = New Uri("url)

    ReportViewer.ServerReport.ReportServerCredentials = New clsSystemReportCredentials

    ReportViewer.ServerReport.ReportPath = "folder/reportname"


    Using Transaction As TransactionScope = New TransactionScope(TransactionScopeOption.Required)

    For Each p As ReportParameterInfo In ReportViewer.ServerReport.GetParameters

    Dim ParameterAdd As New clsDbReportParameterAdd(qReportId, p.Name)

    Next

    Transaction.Complete()

    End Using

     

     

    When this is run we get the error...

    ReportViewer.ServerReport.GetParameters {"Remote report processing requires Microsoft SQL Server 2008 Reporting Services or later."} Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.SoapVersionMismatchException

     

    As Said, we cannot upgrade to 2008 or 2010 SQL Server...

     

    Thanks

    Steven


    Steven Penning
    Monday, October 18, 2010 5:12 PM

Answers

  • You can't.  The ReportViewer controls that ship with VS 2010 rely on the RPL renderer on the report server, which was first shipped with SQL Server 2008.

    You can continue to use the old version of the controls in the VS 2010 development environment, but you won't get design time support (that is, it won't look right on the design surface).  It will function correctly at runtime.

    Wednesday, October 27, 2010 8:27 PM
    Moderator