November 18, 2011 at 3:59 pm
I get a RPC (Remote Procedure Call) Error after changing from Text to Stored Procedure.
I do not get an error on the Data Tab but when I click on Preview I get the error.
SQL Server 2005 SP3. I can't apply SP4 at this time.
Has anyone experienced this?
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/
November 19, 2011 at 8:37 am
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/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply