To search the Course Delegates list

Enter your search term in the search box above the list and press the Return key.

Any entries that match your search term will be displayed.

Click the x at the right hand end of the search box to clear the search.

Sorting, Grouping Filtering, Showing and Hiding Columns

The Customise Grid button will allow you to apply complex sorting, grouping, filtering, showing and hiding options to columns in the grid.

To Sort the list

  1. Click the Customise Grid button
  2. Ensure the Sorting tab is selected
  3. Tick the columns to sort by

The sort direction and order by which the columns are sorted can be adjusted in the upper portion of the dialogue box.

  1. Click the tick button to apply.

Simple sorting can also be applied by clicking the column headings in the grid - once for ascending order, a second time for descending order.

To Group the list

Grouping is most appropriate when it is applied to a column that contains repeated values, such as the Job Group column.

  1. Click the Customise Grid button
  2. Ensure the Grouping tab is selected
  3. Tick the columns to group by

The sort direction and order by which the columns are sorted can be adjusted in the upper portion of the dialogue box.

  1. Click the tick button to apply.

To Filter the list

The Customise Grid dialogue contains powerful filtering tools. Filtering options are adjusted according to the type of data contained in a column, for example a date column will allow filtering between two dates or for a range of preset date ranges.

  1. Click the Customise Grid button
  2. Ensure the Filtering tab is selected
  3. Click the column to filter on
  4. Specify the filtering criteria either by typing a value or, if applicable, by clicking LOAD VALUES TO SELECT and then choosing from the filter options provided
  5. Repeat for any further columns to be filtered on
  6. Click the tick button to apply.

Showing, hiding and reordering columns

  1. Click the Customise Grid button
  2. Ensure the Column Chooser tab is selected
  3. Tick and untick columns to set their visibility
  4. Drag columns up and down using the hamburger icon to change the order of columns
  5. Click the tick button to apply.

Clearing Grouping, Sorting and Filtering Options

The toolbar above the list provides tools for clearing the filtering options applied to the list.

To clear sorting and grouping options use the Customise Grid dialogue box and deselect the grouped / sorted fields.

NOTE: Grid customisation options for the grid are stored to your browser cookies (if available) so that they will be applied the next time you visit the page.

Created with the Personal Edition of HelpNDoc: Full-featured EBook editor