Binding Data

Introduction

The following field containers are available for configuring data binding on a Grid :

• Column(s) : fields that will be Grid columns
• Hidden Column(s) : field that will be in the query but not visible to the user

Columns

Any number of fields of any type can be added as Grid Columns.

The order in the Columns container defines the order of Grid columns from left to right.

Value fields may or may not be aggregated.

Each field groups all the other fields on the right of it.
Changing the order of fields is documented here.

Example

With fields Year, Continent :

The Grid shows the first Year (2016) and all its Continents,(Asia, Europe, North America), then the second Year (2017) and all its Continents, etc… :

With fields Continent, Year :

The Grid shows the first Continent (Asia) and all its Years (2015, 2016, 2017), then the second Continent (Europe) and all its Years, etc… :

Hidden Columns

Optionally, any number of fields of any type can be added as Hidden Columns.

*Hints :
This can be useful for setting up conditional formatting based on calculations that the user doesn’t need to see.
This can also be useful for grouping fields by a field where the values don’t have to be shown to the user.

The Hidden columns group the visible columns.

Value fields may or may not be aggregated.

Example

When configuring a single column called Year :

… the data is grouped, and only distinct values of Year (2015, 2016, 2017) are displayed, and only once :

When configuring additionally a hidden field Continent which has 3 distinct values :

… each Year will appear 3 times : once for each value in Continent :

Code192 2020 All rights reserved