Description

The tile shows the number of the crew with unconfirmed vacation. The view is based on the crew list Unconfirmed Vacation and works only if you have it in your system.

Tile Preview

Data-source

The data-source should be added under the General Codes before setting up the tile. It defines the selection for the tile.

select 
  count (Pin) 
from VIEWID
--where NUMORGID= :P_CLIENTID

Tile and Frame Setup

The tile should be set up in the following way, with the link to the Unconfirmed Vacation crew list view. The rest of the settings are up to your preferences.

The frame should be set up with the link to the proper data-source. The rest of the settings are up to your preferences.

In our example we use:

• Tile Color: LemonChiffon

• Font Size: 11

• Font Name: Arial

• Align: MiddleCenter