Here's a nice one that landed in my lap.

To deliver some reports faster, we decided to develop the crystal reports in parallel with the actual forms. We decided in advanced all the field names and type, etc. However, at the very end, we realized that some data would be better stored in a separate form using the exact same layout. We simply 'saved as' the original form and continued from there.

From inside crystal report, we changed the datasource location to point to the new form. However when we add the report in ITSM's reporting console it fails with 'An error occurred while generating the Crystal report: 0x80047e44 - The table '' could not be found. (ARERR 1904)'

Does this mean that Remedy's ODBC driver doesn't support Crystal's alias system (Change Datasource Location). Will we need to recreate the reports using the new form? Also meaning we will need to maintain two sets of reports because we use two forms?

Seems like the problem is related to the use of underscores.

If we configure the client (or ODBC connection directly) to not use underscore for ODBC, our reports work, but OOTB reports now have the error. If we configure the client to use underscore, our reports result in the error and the OOTB reports work.

Anybody know why exactly?