Datasheet

Crystal Reports TypeSiebel Type
Date-timeDTYPE_DATETIME
StringDTYPE_ID
StringDTYPE_PHONE
StringDTYPE_TEXT
MemoDTYPE_NOTE
Date-timeDTYPE_UTCDATETIME
Note:
DTYPE_PHONE in Siebel is a number. However, for the value to be meaningful, it is necessary to apply
Siebel formatting to the field. To reduce the effort required to add a SQL expression for every
DTYPE_PHONE element, Crystal Reports automatically applies the format and returns the value as a
string.
When filtering the phone type field, the Crystal report automatically removes the formatting and converts
the value into a number. For example:
[Phone Number] = [phone]
will be filtered as
[Phone Number] = 1234567890
24.4 Integrating with PeopleSoft
24.4.1 Overview
If you installed the Data Connectivity feature of the SAP BusinessObjects Enterprise XI, you can work
with PeopleSoft data in SAP Crystal Reports.
2011-05-16629
Integrating Business Applications with Crystal Reports