ITrack/Crystal Reports Failed to retrieve from the database

Cause

Crystal Reports failed to get information to fill out the report, even though it did connect before the failure.

Solution

• In most cases, this error is caused by the specific report.
  • Most likely, the internal query of the report failed when it was run. The report (or database structure) may be out of date.
• Check ODBC, if its pointed to an actual server with a valid username and password but the database/table/field doesn't exist on this incorrect server, you'll get this error.