Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

kvena

Technical User
Aug 5, 2005
19
US
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
 
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
 
Oh, sorry. We are on SQL Server 2005. The ODBC connection is set up the same.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top