CR 8.5 and Oracle

[virtualmode]

HI,
i have the problem when I import a numeric column (INTEGER or NUMBER) from our Oracle-DB, CR makes a number with two decimal places from it.
Okay..i can reformat them but this is not what i need.

I will join this column with a column from a MS SQL-DB and CR can´t join they of cause the decimal places.

 

[kenhamady]

The format you see displayed probably isnt' the problem. This is applied AFTER the records are retrieved

What is the data type - as seen by CR (see faq149-732 ) - of the two fields you are trying to join.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com