SAP Reports 2011, WIN, INTL, NUL 7090310 User Manual
Product codes
7090310
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.
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.
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.
Reports data types for presentation of the table equivalents. The following table shows the conversions.
Crystal Reports Type
Siebel Type
Boolean
DTYPE_BOOL
Number
DTYPE_INTEGER
Number
DTYPE_NUMBER
Currency
DTYPE_CURRENCY
Date
DTYPE_DATE
Time
DTYPE_TIME
2011-05-16
628
Integrating Business Applications with Crystal Reports