, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

OI and Crystal Reports (OpenInsight 32-Bit)

At 18 SEP 2008 01:31:26PM Stephen Sutherland wrote:

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)

At 18 SEP 2008 08:54PM Bob Carten wrote:

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.

At 23 SEP 2008 05:27PM Stephen Sutherland wrote:

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

At 24 SEP 2008 04:43PM Stephen Sutherland wrote:

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

At 24 SEP 2008 05:11PM Bob Carten wrote:

Useful information - thanks for sharing.

View this thread on the Works forum...