User`s guide

Crystal Reports TypeSiebel Type
NumberDTYPE_NUMBER
CurrencyDTYPE_CURRENCY
DateDTYPE_DATE
TimeDTYPE_TIME
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
2012-03-14637
Integrating Business Applications with Crystal Reports