Step 3 : Creating & Managing Work Sheets

Work Sheets are a spreadsheet based on a selected Register, with criteria applied.

They are created in the Work Book screen.

Applying Criteria

Criteria can be applied to a Work Sheet in the form of Selection and/or Sorting.

Selection Criteria

This determines which records (jobs) are displayed in the Register spread by applying field requirements.

Applying Selection Criteria To A Work Sheet

1. From the Work Sheet list, select a work sheet to which the criteria will be applied.
2. With the Sheet selected, from the Manage toolbar group, click . The Select Criteria Selection dialog will be displayed.
3. Enter the details.
4. Click Save. The dialog will close and sorting will be applied to the selected work sheet.

Applying Sorting

This will determine the order of the list when using the Register spread.

1. From the Work Sheet list, select a work sheet to which sorting will be applied.
2. With the Sort panel selected, from the Manage toolbar group, click . The Sort dialog will be displayed.
3. Enter the details.
4. Click Save. The dialog will close and sorting will be applied to the selected work sheet.

Procedures

Adding A Work Sheet

1. From the Work Book list, select a work book to which a new work sheet will be added.
2. With the Work Sheet list selected, from the Manage toolbar group, click . The Work Sheet dialog will be displayed.
3. Enter the details.
4. Click Save. The dialog will close and a new work sheet will be added.