Error in File Warehouse Item Invoice: The table could not be found.

[kvena]

I have a Crystal Report that is returning an Error in File Warehouse Item Invoice: The table could not be found when ran in CMC or InfoView. However, it runs correctly in Crystal Reports XI. I verified the stored procedure was running correctly. I checked the ODBC connection and the Datasource location. Both are set correctly. I can run the report on our test server and I did not receive the error message. I am not receiving this error message on any other production report.

Kelly

 

[synapsevampire]

Is the database type a closely guarded secret?

You state "I can run the report on our test server and I did not receive the error message.", so something is likely different, I'd guess that it's the ODBC set up.

Why wouldn't you post the database type?

-k

 

[kvena]

Oh, sorry. We are on SQL Server 2005. The ODBC connection is set up the same.

 

[synapsevampire]

I generally set up Crystal Reports on the server as well for testing purposes as it gives better error messages.

I still think it's the set up...

-k