Editable grids in Advantage also include an Advanced Grid icon that transforms the grid into a format providing advanced grid capabilities. Advanced Grids include a column menu accessed by hovering your mouse over the column heading and then selecting the column menu icon that appears. Additionally, a side bar displays the Columns and Filters sections in collapsed mode. You can expand the Columns sidebar to access the Pivot table and make changes to the Pivot table as needed. Expand the Filters sidebar to access filter options.
The following functionality is available via the Advanced Grid column menu:
Pin Column – You can pin any column to the left or right side of the grid by selecting one of the following options from the column’s menu: Pin Column > Pin Left or Pin Column > Pin Right. This moves the column to the far left or right side of the grid, based on your selection. This allows you to scroll to the right or left and the pinned column does not move. The Pin Left and Pin Right actions can be selected for more than one column, if desired. Select Pin Column > No Pin to remove the pin from a column.
Autosize This Column – Automatically resizes a column based on the width of the data in the column.
Autosize All Columns – Automatically resizes all columns based on the width of the data in each column.
Group by <Column Name> – Groups all records based on the values in the column. You can also drag columns to the header area of the grid where it says “Drag here to set row groups”. You can remove a grouping by selecting the “x” next to the column name. Note: For performance reasons, grouping by columns is not available if you have selected to view more than 100 records in the grid pagination.
Reset Columns – Sets all columns back to the delivered view.
Expand All – This action is only displayed if the grid is grouped by a column. Selecting this action expands all groups.
Collapse All – This action is only displayed if the grid is grouped by a column. Selecting this action collapses all groups.
Filter – The Filter tab on the column menu allows you to filter by column values.
Columns – The Columns tab on the column menu allows you to remove columns from the grid by clearing the check box next to the column name. This is the same functionality offered via the Configure Columns icon.
To sort all returned rows from the table, it is recommended to perform sorting on the standard grid before switching to the Advanced Grid, if needed.
Once you are in the Advanced Grid view, the column level sort will apply sorting to the current set of records displayed in the grid.
If all rows from the table need to be sorted on the Advanced Grid, then you can use the multi sort icon to apply single or multi column sort to all records. Note: Multi sorting on the Advanced Grid can be a performance intensive task, if you are on a higher ‘View per Page’ such as 5000.