Online Documentation for SQL Administrator for SQL Server

Working with grid


The context menu of the column heads in the grid is the following:

 

Working with grid - Column header popup menu

 

 

Sorting

To sort records in the grid choose the column by which you want to sort data and click the column title.

If the column was not sorted, the first click will sort it in the ascending order and the second one - in the descending order.

Alternatively, you can choose SortAsc Sort Ascending or SortDesc Sort Descending context menu item.

 

Clear Sorting

To cancel the sorting, open the context menu by right-clicking the necessary column and choose the Clear Sorting item.

 

Selecting visible columns

You can specify which columns of the current dataset will be visible. Click the ColumnChooser button available on the toolbar or in the context menu. Drag and drop the column heading from the opened box to the head of the table.

To delete a visible column from the grid drag and drop its heading away from the grid heading.

 

Working with grid - Column chooser

 

 

Changing columns order

For your convenience the possibility to change the order of the columns in the data grid is available. To reorder columns, drag a column caption horizontally to a place in between two other column headers indicated with a black frame.

 

Working with grid - Change column order

 

 

Grouping

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the "Group by" box area at the top. Alternatively you can use the GroupByThisColumn Group By This Column context menu item. To show/hide the "Group by" box area use the GroupByBox Group By Box context menu item.

When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

 

Hint: While dragging the column header back, you can also change the column position.

 

Working with grid - Grouping data

 

 

If necessary, you can group data by two or more columns. In this case column headers are displayed hierarchically, and data are grouped by these columns in the order the column headers appear in the "Group by" area.

 

Working with grid - Grouping data by two columns

 

 

Filtering

A number of filtering facilities are implemented in the grid for your convenience. You can filter records in the grid in either of the following ways:

  • click the filter button next to the column caption to display the drop-down list and select any of the column values to filter records by this value of the selected column;

 

Filtering records

 

 

  • click the filter button next to the column caption to display the drop-down list, then select the Custom item and build a simple filter using the Custom Filter dialog;

 

Working with grid - Custom filter

 

 

  • use the FilterEditor Filter Editor context menu item to invoke the Filter Builder dialog and create a composite filter using the dialog.

 

After the filter is set, the gray filtering panel becomes visible at the bottom of the grid. This panel allows you to see the active filtering condition and easily enable or disable it using the checkbox on the left. The Arrow-down button opens the drop-down menu which allows you to browse the filter history for this dataset.

If necessary, you can click the Edit Filter... button on the right to customize your filter and add more complicated filtering conditions within the Filter Builder dialog.

 

Working with grid - Filtering panel

 

 

To remove the current filter, click the CloseFilterPanel Close button.