Options Tab

This tab is used to specify miscellaneous database settings.

• If the cell colours specified on the Fonts and Colours Tab are to be displayed, check the Always show colours checkbox.

• If cells in Excel reports are to be colour highlighted if they contain values that have changed since a report was last saved as an Excel file or printed, check the Enable change highlight checkbox.

• If column settings are to be saved at project level, for example, they are to be applied to every user that accesses the project on any computer, check the Save settings to Database checkbox. If the checkbox is not checked, column settings are saved at user level instead.

  Note: Saved column settings will be applied to ALL the projects that a user works on.

• If required, in the Start Cell Value field, specify the first cell in which data is to be placed on generated Excel reports.

  Note: This setting will override any start cells specified for individual templates.
  If the application is being run on Windows 7 SP1, a start cell must be specified in the Start Cell Value field, as the facility for specifying start cells for individual templates is not available.

• Specify the location that data is exported to and imported from when modifying Data using Excel Spreadsheets (refer to Modify Database Content with Excel Spreadsheets), and the location to which the Message Log is saved in the Selected Path field.

• If the Customised Report tab is to be displayed (refer to Create Reports with User Defined Queries), check the Display Customised Report checkbox.

• If individual cells are to be colour highlighted if they contain values that have changed, check the Enable highlighting individual cell changes checkbox.

• If required, in the No. of records per page field, specify the number of records to be displayed on each page of the Compare/Update Results list. The default value is 1000, a minimum value of 1000 and a maximum value of 5000 can be specified.