Datasheet

24.3.10 Multi-value columns
There are certain columns within the tables that are displayed through the Siebel driver that represent
multiple values. Crystal Reports will normally display the primary value for these fields. If no primary
ID field is defined, Crystal Reports will display one of the values, but this value is not predictable.
By default, Crystal Reports tries to improve performance by having any sort performed on the server.
In the case of multi-value columns where no primary value has been defined, this will fail. It is necessary
to make any report that needs to sort using multi-value columns perform the sorting on the client.
24.3.11 Data Types
24.3.11.1 Mapping Siebel data types to Crystal Reports types
Siebel supports a range of data types within its business components. These are converted to Crystal
Reports data types for presentation of the table equivalents. The following table shows the conversions.
Crystal Reports TypeSiebel Type
BooleanDTYPE_BOOL
NumberDTYPE_INTEGER
NumberDTYPE_NUMBER
CurrencyDTYPE_CURRENCY
DateDTYPE_DATE
TimeDTYPE_TIME
2011-05-16628
Integrating Business Applications with Crystal Reports