Step 2, in which you select which tiles appear in the dashboard, is shown below:

The value for a tile is calculated by running a report and performing a summary operation on one of the fields in the report. So, in step 2, you'll choose the reports used to calculated the tile values. There are as many tiles as you select reports.

The options in this step are:

• A list containing all reports that have not already been selected appears at the left. The reports are organized in the same folders they are in the Reports Explorer; click the + sign in front of a folder to expand it and see the list of reports it contains. Reports that have ask-at-runtime filter conditions are disabled and cannot be selected because dashboards may run unattended and therefore shouldn't prompt the user for any values.

• A list showing the reports included in the dashboard appears at the right. Reports in this list may be moved up and down to change the order in which they appear in the dashboard; to do this, click the button in front of the report to move and drag the button up or down in the list.

• Add: clicking this button adds the selected report in the available list to the selected list. You can also add the report by double-clicking it in the available list. The report is removed from the available list.

• Remove: clicking this button removes the selected report from the selected list. You can also remove the report by double-clicking it in the selected list. The report is added to the available list (although you may not see it if the folder the report is from isn't expanded).

• Edit: edits the selected report.

• Left and Top: the position of the label displaying the value for a tile.

• Font: the font settings for the label.

• Tile height: the height of a tile.

• Tile width: the width of a tile.

• Refresh every: a dashboard automatically refreshes the data in its reports at an interval you determine. The default is every 600 seconds (10 minutes) but you can set it between 1 and 6,000 seconds. This interval is also used to display sets of tiles; see the note below.

• Automatic number of columns: if this option is turned on (the default), the dashboard window determines how many columns to display based on the number of tiles and the number of rows. For example, if there are six tiles and two rows, the dashboard has three columns. Turn this setting off to manually set the number of columns, especially if you want to cycle through sets of tiles (see the note below).

• Rows: the number of rows to display tiles in. The maximum value is the number of tiles in the dashboard; for example, if you've selected three reports, which gives three tiles, you can have up to three rows (one per tile).

• Columns: the number of columns to display tiles in. The maximum value is the number of tiles in the dashboard; for example, if you've selected three reports, you can have up to three columns (one per tile). This option is disabled if Automatic number of columns is turned on.

  If the total number of cells (rows multiplied by columns) is less than the number of tiles, the tiles are cycled through in sets at the specified interval. For example, if you specify one row and two columns, only two tiles can be displayed at a time, so if the dashboard contains four tiles, the first two are displayed, then the next two, then the first two again.

• No message if no records: with this setting turned off, when the dashboard is run and the filter for a report causes no records to be retrieved, a warning message is displayed. Turn on this setting on to not display the warning.

• Create shortcut: turn this option on to create a shortcut on your desktop that runs the dashboard. To run the dashboard, simply double-click the shortcut; you don't need to start Stonefield Query first and the normal Stonefield Query user interface doesn't appear.

• Require login: turn this option on if you want to prompt the user to log in when they run the dashboard from a shortcut. With this option turned off, the dashboard runs without login. This option is only enabled if Create shortcut is turned on.