I am working on a project to replace reports written in Reporter (aka Report Designer) with reports written in Crystal Reports 2008.

I have successfully recreated 2 reports so far (out of 80), but I am having trouble with the third report.

CR is not recognizing OI native table "symbolic" columns NAME, PAYMENT and INV_GRP_CODE in an OI native table DETAILED_EFTS. CR does recognize all the data columns in DETAILED_EFTS. I can import all symbolic and data columns from this table into MS-Excel using the ODBC driver. And CR has no problems recognizing symbolic columns in other OI native tables (e.g. Table MEMBERS, fields NAME, SORT_NAME)

Is there something I need to set in my DETAILED_EFTS table so that CR can recognize the symbolic fields?

I am running OI version 7.1. The Revelation ODBC driver is 1.00.06.01. Crystal Reports is 2008 (v12)

Try turning on the trace function in the ODBC driver.

You may be able to see a difference between the requests and responses sent from Excel and those sent from crystal. That could provide a starting point.

Thanks Bob. I ran the ODBC SQL trace on both the Excel and Crystal Reports ODBC access, but I've got to admit it doesn't tell me a thing.

Correction to my original post – I cannot get Crystal Reports to recognize any symbolic column (though Excel acknowledges them all).

What I really need to know is – Is anyone else producing a Crystal Report from an OI native table able to include symbolic columns or not? If it simply is not possible, then I'll figure out a workaround.

Thanks

I figured it out. I need to give Crystal Reports the SQL command, rather that using CR to pick table and columns.

Useful information - thanks for sharing.

View this thread on the Works forum...