What is a Table?

What is a Table?

Zoho Reports stores all your tabular data/datasets in entities called Tables. A table contains a set of columns and actual data rows (similar to a spreadsheet). Each column has a name and a type (data type) associated with it.A table in Zoho Reports is identified with this icon ... 

A Zoho Reports database could contain a collection of tables. Two tables could be related to each other using lookup columns, thus enabling you to model a relational reporting database (Refer Relating tables using Lookup columns). You can create any type of reports over these tables which contain the actual data.

Type of a column defines the nature of values a column can contain and the operations that can be done over the same. e.g., an Age column could be "Positive Number"  type.This column can contain only positive numbers and you could apply arithmetic operations over the same. Click to read more about the data types supported by Zoho Reports.

A database would typically contain one or more tables containing logically related datasets. e.g., a Sales database could contain Products, Sales, Purchase etc., tables. Users are recommended to have logically related datasets stored within the same database, with each distinct dataset stored as a separate table. As mentioned earlier we can also define relationship between two tables using Lookup columns.