ITrack/IDispatch error 31826

Failed to retrieve data from the database.

Cause

This error occurs when Crystal was able to connect to a MySQL database, but the report query returned with an error.

Solution

Possible reasons the query would fail:

• Something wrong with the report you are trying to print.
  • Report isn't up-to-date
  • User's database is not up to date
  • Correct parameters were not passed in to the report.
• The ODBC driver is pointed at the wrong server.
• The wrong report may be referenced in Edit > Options > Reports tab, causing ITrack to think that incorrect parameters are being passed in.
• If you are able to successfully run the report query in SQLYog, but the report still won't print, try checking on the definers for the functions related to files/attachments.