Visual Basic Crystal Reports - Error when using Stored Procedure as datasource

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Error when using Stored Procedure as datasource

kathyk

2006-03-29, 7:06 pm

Good afternoon,
I am using Crystal Reports v.9 and SQL Server 2000. I am trying to
create a report using a Stored Procedure and I get an error that states
"Not Supported Details: Cannot get error from server" when I select the
SP as my datasource and enter date parameters.

Other reports are using this stored procedure but they were created by
someone else. They are running successfully. Any ideas how I can
troubleshoot this?

The stored procedure has one unusal aspect. It calls a stored procedure
on another server that puts data into a temp table. That data is then
copied to this server. The stored procedure doesn't generate errors
when I run it on the server.

I don't have very much experience with stored procedures or crystal
reports so I would appreciate any help!

Thanks,
Kathy

Sponsored Links