The Options item in the Tools menu allows you to configure Stonefield Query so it works properly for you.

The options in the General page are:

  • Display real table and field names: if you are familiar with the name of your application's tables and fields, you might find it easier to locate the tables and fields you want by their real names. If you turn this option on, Stonefield Query displays the real name followed by the descriptive name in parentheses.

  • Report preview opens in new window: if you turn this option on, reports are previewed in a new tab in your browser. With this option off, the Preview window appears inside the same browser tab as the rest of the dialogs.

  • Use 24 hour time format: turn this option on to display times in 24-hour format, such as 15:25:00 for 3:25 p.m. Turn it off to display times in 12-hour format, such as 3:25 PM.

  • Default quick report template: this setting determines the default template used for new quick reports.

  • Default crosstab template: this setting determines the default template used for new cross-tab reports.

  • Locale: this setting determines the formatting of numeric and date values. For example, 1400 appears as $1,400.00 when Locale is set to English (United States) and 1.400,00 € when it's set to Deutsch (Deutschland), while July 4, 1996 appears as 07/04/1996 for English (United States) and 04.07.1996 for Deutsch (Deutschland).

  • Theme: this option allows you to change the theme of the application, which affects the appearance, including colors and fonts. For example, here's what the Amelia theme looks like:

  • Length units: this setting determines the units for measurements such as field width: inches or centimeters.

The options in the Email page are used when you want to email a report to someone or if an unexpected error occurs in Stonefield Query, in which case you have an option of emailing an error report to us so we can resolve the problem. The options are:

  • Name: your email descriptive name, such as "John Doe."

  • Email address: the email address to use as the "reply to" address.

  • Mail server address: the address for your mail server.

  • SMTP port: the port for your SMTP mail server. This defaults to 25, but can be changed if necessary.

  • Email server requires authentication for outgoing: turn this option on if applicable.

  • User name: the user name to use if the Email server requires authentication for outgoing option is turned on.

  • Password: the password to use if the Email server requires authentication for outgoing option is turned on.

  • Use SSL/TLS: turn this setting on if your email server uses SSL/TLS.

  • POP connection before SMTP: turn this setting on if your email server requires a POP connection before using SMTP.

  • POP server address: the address for your POP mail server. This setting only appears if POP connection before SMTP is turned on.

  • POP port: the port for your POP mail server. This setting only appears if POP connection before SMTP is turned on.

Click the Test settings button to test that the email settings are correct by sending an email to the address you entered.

The Saved Email Addresses page allows you to manage any email addresses that have been saved after being entered in the export options for a report. To remove an email address that has been saved, select it in the list, and then click the button.

The Server Settings page is only available for users in the Administrator role. The options are:

  • Run schedules under this server/domain account: turn this setting on if you want to specify the credentials (Windows user name and password) for scheduled reports. If these are filled in, the user doesn't have to specify them when creating a schedule.

  • Use Active Directory authenication: if your system uses Active Directory and you don't want to add users to Stonefield Query manually, turn this setting on and specify the domain name. Any Active Directory users in that domain are automatically Stonefield Query users.

Other settings

In addition to these settings, there are several settings you can customize in the appSettings section of web.config in the program folder. You can use any text editor (such as Notepad) to edit these settings. Do not alter any part of web.config other than the items listed below or Stonefield Query may not work properly or at all.

The settings you can edit are:

  • Stonefield Query can run in an IFrame by default. To disable this behavior, set the "supportiframes" setting to false.

  • Loupe, a utility from Gibraltar Software (http://www.gibraltarsoftware.com), provides advanced logging features and an easy-to-use (and free) log viewer. By default, Stonefield Query uses Loupe for logging. If you encounter problems with Loupe, change the "useloupe" setting to false. Also, edit logger.config in the Logs folder and remove this line:

      <appender name="GibraltarAppender" type="Stonefield.Query.Web.GibraltarAppender, SQ WEB">
    
  • By default, Stonefield Query uses SSL to communicate with the browser. This encrypts traffic between the server and the browser rather than sending clear text. We highly recommend you do not turn this off, but if you must, add a custom setting "usessl" setting with a value of false.