Home Forums Reporting Services Reporting Services 2005 Development RPC (Remote Procedure Call) Error after changing from Text to Stored Procedure RE: RPC (Remote Procedure Call) Error after changing from Text to Stored Procedure

  • November 19, 2011 at 8:37 am

    #1410314

    I create the initial report using the Wizard and the only option is to specify text as a Data Source..

    Then I add a footer and page header, format the report, add an image, etc.

    If I switch the Data Source to a Stored Procedure I get the correct values when I execute from the Data Tab but when I swith to the Preview Tab I get different Numbers or the RPC Error.:w00t:

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/