Data Types Supported in Zoho Reports
Data Type/Column Type of a column in a Table defines the nature of values a column could contain and the operations that could be done over the same. Eg., an Age column could be "Positive Number" type. This column can contain only positive numbers and you could apply arthimetic operations over the same.
Data type of a column also determines the formatting options that are possible for displaying the values in the column in various reports created in Zoho Reports.
Zoho Reports supports the following data types (column types) currently.
Data Type | Category | Description |
| Plain Text | Text | Holds a line of simple text. |
| Multi Line Text | Text | Holds multiple lines of text |
| E-mail | Text | Holds an Email Address |
| URL | Text | Holds a clickable Hyperlink / Web URL address. eg., http://reports.zoho.com |
| Number | Numeric | Holds an integer value (both positive and negative values) |
| Positive Number | Numeric | Holds only positive integer values |
| Decimal Number | Numeric | Holds decimal values (both positive and negative) |
| Currency | Numeric | Holds a currency value in different country denominations |
| Percent | Numeric | Holds a percentage value |
| Auto Number | Numeric | Holds auto
generated incremental numeric values, which are unique. This would be
helpful when you need to have a unique identifier associated to each
row/record in the table.
Auto Number column value starts with 1 and each new value will be incremented by 1. Auto Number values will always be unique
|
| Date | Others | Holds Date and Time value |
| Decision Box | Others | Holds a binary value eg., Yes/No, True/False, On/Off |
| Looked Up Column | Others | Refers to a column value in another table. Helps to relate two tables. Click to know How to create a Lookup Column. |
Related: Create New Table
Next: Relational Data Modeling in Zoho Reports
