A script-enabled browser is required for this page to function properly.

Datatype property

The Datatype property specifies the type of the column's contents.

Applies to

Columns

Values

Character, Date, Long, Long Raw, Number, Raw, Varchar, Varchar2

Trusted Oracle datatypes (MLSLABEL and ROWLABEL) are supported by Reports Builder. When running on an operating system with Trusted Oracle, Reports Builder treats these columns as Trusted Oracle datatypes. This means that the columns can be properly sorted. When running on an operating system without Trusted Oracle (for example, Windows), Reports Builder treats these columns as character datatypes.

Default

For database columns, the default Datatype is derived from the database. For summary columns with a Function of Count, the default Datatype is Number. For other summary columns, the default is derived from Source. For formula, placeholder, and sort columns, the default Datatype is Number.

Required/Optional

Required 

Restrictions