Using grids in eVolve software
This document is intended to help navigate through grids. While the document may not go over all available options it should help to provide a basic understanding to help better utilize the functionality of the grids. The functions and processes contained within this document are not product specific and may be applied to all eVolve software.
The GridView is the default Data Grid View that displays data in a traditional tabular format. Each data source record is represented as a row, and all data source data fields have related columns. Data portions are stored within individual cells.
To group data by a column, drag a column header into the Group Panel.
Another option is to right-click a column header and select Group By This Column.
To ungroup data, drag a column header from the group panel to the column header panel.
Another option is to right-click a column header and select Ungroup from the context menu.
To remove all grouping, right-click the group panel and select Clear Grouping.
When data is grouped by multiple columns, you can drag a column header to another position within the group panel to change the group order.
Merged Column Grouping
Hold the Ctrl key when dragging column headers into the group panel to group data by multiple columns at once.
Compare how the row information is displayed as compared to the image above.
By default, data may be sorted by any column. Click a column header once to sort data ascending. Consequent clicks will reverse the sort order. Sort glyph (up or down arrow) in column headers indicates the current sort order.
To sort data by a specific column, right-click the column's header and select Sort Ascending or Sort Descending.
The Data Grid discards the currently applied sorting when a column header is clicked and keeps the sorting when applied through header’s context menus. Thus, to sort data by multiple columns, either utilize header context menus or hold the Shift key down when clicking column headers.
In the image above, note how Tag Type is sorted ascending, Category is sorted descending, and Service Type is sorted ascending.
When filtering is applied to a View, displayed records are restricted to those that meet the current filter criteria. Data may be filtered against single or multiple columns.
Filtering Dropdown Menus
To invoke a filtering dropdown menu for a column, click the filter icon within the column header.
In the Values tab, users can select specific cell values from those that are currently displayed by the Data Grid.
The Filters tab gives users a wider pool of filtering options. For example, when filtering by dates, you can only show those records that correspond to the previous week.
The content of a filtering dropdown menu depends on the type of data displayed by the related grid column. For instance, the figure below illustrates what this menu looks like when filtering by a text column.
While some features may not be applicable, you can view more information about grouping, sorting, and filtering grids on the DexExpress website.
When filtering is applied, a View shows a filter panel. The Filter Panel is used to modify and remove current filters.
The Filter Editor dialog allows end-users to build complex filtering criteria, combined from multiple expressions. To invoke this dialog end-users can do one of the following:
· click Edit Filter in Filter Panel
· right-click a column header and select Filter Editor
For more information about the Filter Editor may be found on the DexExpress website.