Difference between revisions of "ITrack/Crystal Reports Failed to retrieve from the database"

From ISoft Wiki
Jump to navigationJump to search
Line 3: Line 3:


== Solution ==
== Solution ==
In most cases, this error is caused by the specific report.
* 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.
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.
* 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.


[[Category:ITrack/Problems/Crystal Reports]]
[[Category:ITrack/Problems/Crystal Reports]]

Revision as of 11:24, 17 March 2011

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.