Crystal Reports Server XI - Invalid Object Reference Error

[CrystalQB]

I am working with Crystal Reports Server XI.
The datsource for my reports is a Stored Procedure in SQL Server 2005.

The report runs fine in my development environment, both on my machine and when I run it on the reports server itself. (remote desktop)

And I can sucessfully upload it to the Enterprise environment (InfoView) But when I try to run it, I get a failed connection error.

I've had my administrator check the server for the error message he gets when it runs and it says
Invalid object reference

I've confirmed the ODBC DSN exists on the server,
I've done the Service packs,
I've changed the DSN to a SQL Authenticated connection,
I've been trying to run it logged in as administrator to make sure it's not a user rights issue,

What am I missing? If anyone has any ideas I would really appreciate a shove in the right direction to find this solution.

BO support has gotten even worse byt his whole SAP take over so I'm all alone in this problem, and have higher ups breathing down my neck for a solution...please help.

Frantic,
CrystalQB

 

[IanWaterman]

In Crystal Reports the default setting is to exclude Stored Procedures. You have to go in to File-> Options and check Stored procedures.

Have you checked that your server settings for Crystal will see SPs?

Ian