I have an urgent need with Crystal Reports 10.0 and SQL Server 2005 and it is a strange one.
I am logged into my client domain via my laptop and I do not have a domain login to my client's domain. I work on their SERVER using a password they gave me for remote desktop (via mstsc). I access the SQL Server 2005 databases using the 'sa' password for SQL Management Studio. Then I have Crystal Reports 10.0 locally installed on the SERVER machine. Whenever I write or modify a stored procedure in SQL Server 2005 and try to link it to my Crystal Reports 10.0 or verify it, it says that the stored procedure sp_TestProc;1 cannot be found, do you want to proceed to remove this table from the report? I am forced to click NO.
The only way it seems to link right is by using a permanent table that I create in SQL Server 2005 to store the results of my stored procedure and then link it to my report. I have had enormous success in the past linking my Crystal Reports 10.0 to stored procedure result sets. This is very frustrating for me as I cannot verify a damn thing I change in my stored procedure. I am forced to either create a table or an entire new report just to see the impact of 1 modified field. Hope that explains my frustration. What is causing this? I execute my stored proc in SQL Management Studio and it works like a charm and returns records.