We had a set of Crystal reports running without out scheduled with Logicity, the initial reports had two datasasources, a sql database and an excel spreadsheet. We've since moved the data from the excel spreadsheet to a new table created in the sql database, the Crystal reports were updated and they run fine on my PC, when copied over to the server that runs the scheduled Crystal reports we now get a "Table could not be found" error for those reports.

Found the error, the new table that was created in the database did not have the proper user permissions, added those and now all works well.