Customise Drill Down

You can customise the Drill Down area in the way as the Employee View area. This topic shows how to customise Drill Down from the "Default" layout to the "Training" layout.

"Default" layout:

"Training" layout:

Relabel headers

Some "Default" Clock headers are unclear so you need to change their captions.

1. Click a cell in the first Clock column.
2. Press Alt+F10.
3. On the Customise Column Extensions | Details tab, change Caption to "ClockIn".
4. Click OK.
5. Click a cell in the second Clock column.
6. Press Alt+F10.
7. On the Customise Column Extensions | Details tab, change Caption to "ClockOut".
8. Click OK.

Rearrange headers

You need to rearrange headers into a more logical order.

1. Drag-and-drop ClockIn to the left of the first Flg (Flag) header.
2. Drag-and-drop ClockOut to the left of the second Flg (Flag) header.
3. Drag-and-drop Reason to the left of the Break header.

Remove Headers

You need to remove headers that are not used in the "Training" layout.

1. Drag-and-drop Break Code, WorkArea, and Location out of the header area.

Add Headers

You need to add headers for hours worked and clock results.

1. Press F10 to see the Customize box.
2. Drag-and-drop Hours Worked to the right of the End header.
3. Click a cell in the Hours Worked column.
4. Press Alt+F10.
5. On the Customise Column Extensions | Details tab, change Caption to "Worked".
6. Click OK.
7. Drag-and-drop Rlt to the right of the Worked header.
8. Close the Customize box.

Customise Display Settings

You need to display reasons as red text on a white background.

1. Click a cell in the Reason column.
2. Press Alt+F10.
3. On the Customise Column Extensions | Details tab, change Customise colours to "Yes".
4. In the colour palette, left-click red and right-click white.
5. Click OK.

You need to display clock results as white text on a red background.

1. Click a cell in the Rlt column.
2. Press Alt+F10.
3. On the Customise Column Extensions | Results tab | Details sub-tab, change Customise colours if results to "Yes".
4. In the colour palette, left-click white and right-click red.
5. Click OK.

You need to display start and end times as black text on a light blue background.

1. Click a cell in the Start column.
2. Press Alt+F10.
3. On the Customise Column Extensions | Details tab, change Customise colours to "Yes".
4. In the colour palette, left-click black and right-click light blue.
5. Click OK.
6. Repeat this process for the End column.

Optimise Column Widths

You need to optimise the width of the Drill Down sections.

1. Place your cursor on the border between the Dates and Times sections.

   Your cursor changes to a double-headed arrow.

2. Double-click the border to optimise the width of all columns in the Dates section.
3. Place your cursor on the border between the Times and Details sections.
4. Double-click the border to optimise the width of all columns in the Times section.
5. Place your cursor on the right border of the Details section.
6. Double-click the border to optimise the width of all columns in the Details section.

Save Layout

You need to save your changes as the "Training" layout.

1. Save your layout as "Training". See Save Layout.

Topic: 3472