Varchar2 Field Read as Memo

[LadyJAG]

I'm using CR8.5 and an Oracle10 database through an ODBC system DSN connection.

I'm using an oracle stored proc to bring back a record set to the report. One of the fields I'm brining back is a varchar2(60) field. Crystal seems to think that this is a memo field so I can't group on it.

Any ideas why this is happening?

 

[synapsevampire]

It may be beacause you are using the wrong type of connectivity.

You should use Oracle native connectivity for the best performance (listed as Oracle Server I believe), not ODBC.

If you insist upon using ODBC, use the Crystal supplied ODBC driver, not the Oracle supplied ODBC driver.

Even if the field is over 254 characters in the database, you can use a SQL Expression to cast it to 254 characters and then group on the SQL Expression (this will be performed on the database and therefore will be fast).

-k