Switch data source from SP to Table

[MSBrady]

Oy!

SQL Server 2005
CR 10

I have found posts relating to moving from a Table to a SP but I am trying to go the other way; SP to Table and I am getting an error: 'Cannot obtain error message from server.'
I used Set Location and it seems to work but this error shows up at runtime. The SP has a parameter that the report continues to ask for also.
I'd rather not do this one formula at a time as there are over 40 and I have 2 reports that I am doing this for.

TIA

 

[MSBrady]

Cancel. I tried it again this afternoon and it worked.