Supported Data Fields

This page is currently under review. Stay tuned!

In this page, you will find the complete list of Data Fields supported for each Data Source.

crystal Attribute Type List

First of all, let's recap the Data Field supported by Crystal.

Type	Notes
Categorical	Used mainly for filter dimensions. crystal will not perform calculation (e.g. Sum or average) on these formats.
Numeric	Used mainly for main entities that need aggregations and numerical filters.
Date & Time	Used for time dimension (filter entity). If not formatted accordingly, crystal will not be able to show data with a time perspective.
Boolean	Used for entities that can assume binary values

Now, let's deep dive into each Data Source!

PostgreSQL

Type	Format
Categorical	char character varying character text varchar
Numeric	bigint decimal double precision integer money numeric real smallint
Date & Time	date timestamp
Boolean	boolean

MySQL

Type	Format
Categorical	char character varchar tinytext text mediumtext longtext blob enum set
Numeric	tinyint smallint integer int bigint decimal numeric float real double precision double
Date & Time	date time datetime timestamp year
Boolean	boolean

Microsoft SQL Server

Type	Format
Categorical	char varchar text nchar nvarchar ntext uniqueidentifier
Numeric	bigint decimal int money numeric smallint smallmoney tinyint float real
Date & Time	date datetime datetime2 datetimeoffset smalldatetime time
Boolean	bit

Oracle

Type	Format
Categorical	varchar2 nvarchar2 char nchar varchar
Numeric	number float long int decimal real
Date & Time	date timestamp
Boolean	raw

IBM DB2

Type	Format
Categorical	CHAR VARCHAR CLOB BINARY VARBINARY BLOB
Numeric	SMALLINT INTEGER BIGINT DECIMAL REAL DOUBLE DECFLOAT
Date & Time	DATE TIME TIMESTAMP
Boolean	BOOLEAN

Amazon Redshift

Type	Format
Categorical	char nchar bpchar character varchar nvarchar character varying text
Numeric	int2 int int4 int8 numeric float4 float8 float bigint decimal double precision integer numeric real smallint
Date & Time	date timestamp
Boolean	boolean bool

SAP Hana

Type	Format
Categorical	nvarchar varchar shorttext alphanum
Numeric	bigint integer smallint tinyint decimal smalldecimal double real float
Date & Time	date time timestamp seconddate
Boolean	boolean

Azure Synapse

Type	Format
Categorical	char varchar nchar nvarchar
Numeric	bigint decimal int money numeric smallint smallmoney tinyint float real
Date & Time	date datetime datetime2 datetimeoffset smalldatetime time
Boolean	bit

MongoDB

Type	Format
Categorical	string
Numeric	double decimal int long
Date & Time	date timestamp
Boolean	boolean

Google BigQuery

Type	Format
Categorical	string
Numeric	integer float numeric bignumeric
Date & Time	date datetime
Boolean	boolean

---