Display

The Display section allows you to specify how the column values should be displayed based on your needs. You can add or configure various display properties for column values and headers, such as format, display name, thousand separator, prefix, suffix, and the option to hide specific columns.

Display properties

1. Format

Using the Format property, you can define how the date and date-time values should be presented in the columns. You can choose from various date and date-time formats such as 'MM/DD/YYYY', 'DD/MM/YYYY', 'DD MMM, YYYY hh:mm:ss', and so on.

2. Display Name

The Display Name property enables you to display a user-friendly name for the column header, different from the actual field name in the database. For instance, the 'cust_id' field in the database can be displayed as 'Customer ID' in the visual for enhanced clarity.

3. Description

You can use the 'Description' field to include additional information to the column headers, helping users understand the data better. An 'i' icon is added beside the header name and when you hover over it, the additional description is shown.

4. Thousand Separator

By default, numbers in the column are displayed continuously without any thousand separators. To enhance the readability of large numeric values, you can add a comma, a period, or a space as a separator for every group of thousands.

5. Prefix

This property allows you to add a prefix of up to two characters before numeric or decimal column values. This is commonly used to indicate currency symbols.

6. Suffix

This property lets you add a suffix of up to two characters after numeric or decimal column values. This can be used to indicate measurement units or percentages.

7. Hide Column

The 'Hide Column' property allows you to hide a column from view. Check this box to hide a specific column. This is useful when certain data is not required to be displayed but should be kept in the table.

We have now discussed all the column properties that can be configured from the 'Manage Columns' window. In the next section, we will look at the 'Security' tab in the same window, where we can set the access control for columns.