Data Grid#
A data grid is used to display data in tabular form, thus allowing for easy data structuring and segmenting.
Column Options#
All data grids include the icon, which opens the Column Options wizard. From this wizard, you can:
- Add additional columns by selecting the required properties.
- Change the order of the selected columns by dragging and dropping them or by using the and arrows.
- Remove columns using the icon.
After customizing the data grid, select Apply to implement the changes.
Column Sizing#
There are several options available to change the size of the columns in a Data Grid:
-
Fit to headers - the grid will be resized so that the column width matches the maximum size of the current header content.
-
Fit to cells - the grid will be resized so that the column width matches the size of the maximum content present in the data section of the grid.
-
Auto fit - the grid will be resized so that it can achieve a balance between header width and data width.
-
Fit to grid width - the grid will be resized so that it can occupy the maximum possible space in the screen.
Exporting Grid Data#
The system also allows exporting the current data from the grid to a comma-separated value formatted file by selecting the More button and selecting the Export option together with the appropriate format.
The exported file reflects the columns and values as shown in the grid. It uses the visible column titles, and resolves names and links to the text you see on screen. Columns that hold only an internal identifier and the selection column are not included.
The export includes all records of the grid, not only the records on the currently loaded page.
The exported file is UTF-8 encoded, so special characters display correctly when you open it in Excel.