Long datatypes using Crystal 9 truncated to 2 chars

[suefletcher]

I can’t report on Long datatypes using Crystal 9.

I have the force retrieval of longs set in my oracle ODBC however only 2 characters are displaying.

I’d appreciate it if I could get an answer on how to report on ‘longs’ as soon as possible as I need to start using this column in my reports

 

[synapsevampire]

Don't use the Oracle ODBC driver, use the Crystal supplied ODBC if you prefer to use the slower ODBC connectivity, but you're better off using the Oracle native connectivity (I assume that's what you're using, you should state how you're connecting).

You'll find it under Create New Connection->Oracle Server.

-k