We help IT Professionals succeed at work.
Get Started

Problem verifying Crystal Reports 10.0 report with SQL Server 2005 stored procedure

2,305 Views
Last Modified: 2011-10-10
Hi,

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.

Chad
Comment
Watch Question
Software Solutions Consultant
CERTIFIED EXPERT
Top Expert 2006
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE