| Alexander Mueller 2006-01-21, 7:01 pm |
| 17.01.2006 15:01, Alexander Mueller schrieb:
> Hi
>
> I habe a VB-6 application using Crystal reports 8.0.1.0
> with an ADO-Oracle Datasource. Oracle version is afaik 8.x
>
> For some reason the field-explorer doesn't display numeric fields
> (double or integer) only fields whose datatype is string or date.
>
> Nonethelsee all fields are displayed in the 'visual relation-wizard'
> (this is translate from german) and date-import from the
> string and date fields works as expected.
>
> Is this a known issue or do i have to change the oracle-driver
> some subtle connection settings or what else?
In case someone else will encounter the same problem:
The problem only occurs if the VIEW that serves as data source for
Crystal Reports uses a UNION statement. Then crystal report 8.0 only
allows string- and date-fields, but not numeric fields to be used
in the report.
And the workaround is to make numeric fields also character
fields using PL/SQL-TO_CHAR (or other string functions),
which of course is a limitation to what you n do with the data inside
the report.
According to crystal feature information the UNION-problem is
fixed in 8.5 and later versions.
Best regards,
Alex
|