Grid View

<< Click to Display Table of Contents >>

Navigation:  Professional > Navigation & Workspace >

Grid View

Grid

Context Menu

Group By

 

In EQuIS Professional, the data grid offers several options for viewing and exporting data in EQuIS tables, views, or grid reports. It consists of several areas:

The grid toolbar

The grid with the data records, or grids if expanding a row with the Add Related Tables feature (pictured below)

The Add New Record row

 

15266-table-and-view-options

 

Grid

 

There are several components to the grid:

Details on the displayed grid, such as the runtime or the number of records retrieved, visible (such as if a table or report has been filtered), and selected

Column names

A filter row, if filters are enabled

Data rows

grid_ref_dropdown

Data rows will include dropdowns in fields/columns with dates or with foreign key references to other tables. Some dropdowns, such as for FACILITY_ID or CAS_RN, will show information from multiple columns; only the value in the first column is used.

 

Context Menu

 

The following options are available after right-clicking within a grid:

Related Tables show parent or child table entries for each record (only available in tables)

Column Chooser configure how columns display

Group By turns on Group By mode, described below

 

15266_grid_context

 

Group By

 

Right-click on the grid and select Group By to enable Group By mode. The Group By bar will appear in grey above the columns with instructions:

 

15266_groupby_bar

 

Drag a column to the Group By bar to group by that column. Drag a column out of the Group By bar to remove that grouping. Dragging multiple columns will group by each, in order:

 

15266_groupby_multi