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

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).

  • Refresh every: a dashboard automatically refreshes the data in all of its reports at an interval you determine. The default is every 10 minutes but you can set it between 1 and 99 minutes.

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

  • 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, which it is by default, 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.