The General page of the Field Properties dialog has the following options:

• Expression: the name of the field or the calculated expression to print. You can use a built-in function or user-defined function for the expression. Click the Expression Builder button (the "..." button) to display the Expression Builder.

• Object position: it's possible the height of a band can change when it's printed. For example, the detail band may only appear as one line high in the Advanced Report Designer, but if a field's Stretch with overflow setting is turned on (see below), that field may take more than one line if it contains a lot of information, and therefore so does the detail band. The object position settings allow you to specify what happens to objects when the band they're in changes height. The choices are:
  • Float: specifies that the selected object moves vertically relative to the size of objects directly above it.

  • Fix relative to top of band: as the band changes height, this object maintains its position relative to the top of the band.

  • Fix relative to bottom of band: as the band changes height, this object maintains its position relative to the bottom of the band.
    

• Stretch with overflow: causes the field to expand down if there is more information in the field than can be displayed on one line.

• Size and position in layout: rather than trying to precisely size or position an object using the mouse or arrow keys, you can specify the dimensions and location of the object using these controls.

• Rotation: you can rotate an object on the report by specifying the rotation angle. Positive numbers mean clockwise rotation and negative numbers mean counterclockwise. Note the object doesn't appear rotated in the Advanced Report Designer, but only when the report is run.

• Create/update column heading: turn this option on if you want Stonefield Query to automatically create a column heading for a new field or update the associated column heading for an existing field. This is useful if you want a column heading to always be in sync with the associated field. For example, changing the field expression so it references a different database field should likely change the caption for the column heading. Turning this on will do that automatically. However, you may want to turn this off if you're creating a field in some band other than the detail band, because you probably don't want a column heading added to the Page Header band in that case.

• Adjust field width automatically: this option, which is only available for new fields or if you change the expression for an existing field, automatically sizes the field correctly for the expression you enter if it is turned on. This is useful because it ensures the field isn't too narrow or too wide for the data displayed. However, if you specifically sized the field to a desired width, turn this setting off so it doesn't override your size.
  

The Style page of the Field Properties dialog has the following options:

• Font: allows you to select the font name, style, size, and script for the field.

• Use font script: turn this option on to use the script selected in the font dialog for the field. This is only necessary in languages that use something other than Western script, such as Hebrew, Arabic, or Cyrillic.

• Strikethrough: turn this setting on to apply the strikethrough style to the field.

• Underline: turn this setting on to underline the text in the field.

• Use dynamic expression for font style: if you want the font name, size, or style of the field to change depending on the contents of this or some other field, turn this setting on and click the Expression Builder button. The following dialog appears:

  

  In this dialog, enter the expression you wish to look for (you can click the Expression Builder button to launch the Expression Builder, which makes it easier to enter the expression) and the font style to use when that expression is true. You can enter up to three expressions to change the font style. If none of the expressions is true, the font style specified for the field is used.

  Note that using this option significantly increases report generation time, so use it only when required.

• Use default foreground (pen) color: turn this setting on to use black text for the field. If you turn this setting off, the button beside it is enabled so you can select color to use.

• Use default background (fill) color: turn this setting on to use a white background for the field. If you turn this setting off, the button beside it is enabled so you can select color to use. Note that when you change the background color of a field, you must also change the Backstyle setting (see below) to Opaque or the color won't show up on the report even though you see it in the Advanced Report Designer.

• Use dynamic expression for color: if you want the color of the field to change depending on the contents of this or some other field, turn this setting on and click the Expression Builder button. The following dialog appears:

  

  In this dialog, enter the expression you wish to look for (you can click the Expression Builder button to launch the Expression Builder, which makes it easier to enter the expression) and the color to use when that expression is true. You can enter up to three expressions to change the color. If none of the expressions is true, the color specified for the field is used.

  Note that using this option significantly increases report generation time, so use it only when required.

• Backstyle: this setting determines whether objects behind this one can be seen (the transparent setting) or are covered by this object (the opaque setting).

• Sample: shows an example of what the text looks like based on the settings you've selected.
  

The Format page of the Field Properties dialog has the following options:

• Format expression: specifies how the field is formatted. Normally, this is only used for numeric values to indicate whether commas are displayed or not and how many decimal places to use (use "9" as a placeholder for a digit and enter an expression such as "9,999,999.99" to specify where commas and decimals go). However, if you have a character string you'd like formatted in a certain way, you can enter an expression indicating how the string appears. For example, if telephone numbers are stored as just digits (for example, 7085341212), you can format them with parentheses and dashes using "(999) 999-9999".

• Character, Numeric, and Date: specifies the data type of the field and determines which of the following options are available.

• Template characters: this setting, which is only available when Character is selected, specifies how to handle the format expression. Overlay means punctuation symbols in the expression take the place of characters in the string. To continue the telephone number example above, choosing this option results in "(085) 121-" displayed because the opening parenthesis overlays the "7" in the field value, the closing parenthesis overlays the "3," the space overlays the "4," and so on. Normally, you should choose Interleave, which means the characters in the format expression don't overlay the field value but are instead interleaved with them.

• To upper case: converts all characters to uppercase. This item is only available when Character is selected.

• Alignment: specifies the alignment of the field: left, center, or right. This item is only available when Character is selected.

• Trim mode for character expressions: this setting determines what to do if the value of the field in a particular record is longer than the space allocated in the report. The choices are:
  • Default trimming: an ellipsis (...) is added to the end of the text indicating there's more data that can't be seen.

  • Trim to nearest character: this cuts off the text at the last character that fits.

  • Trim to nearest word: this cuts off the text at the last whole word.

  • Trim to nearest character, append ellipsis: like Trim to nearest character, but adds an ellipsis.

  • Trim to nearest word, append ellipsis: same as Default trimming.

  • Filespec, show inner path as ellipsis: characters at the start and end of the expression appear but middle characters are replaced by an ellipsis.
    

• Left justify: numeric fields are normally right-justified. Turn this option on to use left justification. This option is only available when Numeric is selected.

• Blank if zero: displays a blank space if the field contains zero. This item is only available when Numeric is selected.

• (Negative): places negative numbers in parentheses. This item is only available when Numeric is selected.

• Scientific: displays very large or very small numbers in scientific notation. This item is only available when Numeric is selected.

• CR if positive: displays "CR" (credit) after positive numbers. This item is only available when Numeric is selected.

• DB if negative: displays "DB" (debit) after negative numbers. This item is only available when Numeric is selected.

• Leading zeros: prints all leading zeros. This item is only available when Numeric is selected.

• Currency: displays the currency symbol specified in the Regional Settings of your Windows Control Panel in front of numbers. This item is only available when Numeric is selected.

• Blank if empty: if this option is turned on, a blank is displayed rather than " / / " for blank dates. This option is only available when Date is selected.

• Use long date setting: this setting displays dates using the Long Date setting specified in the Regional Settings of your Windows Control Panel. This option is only available when Date is selected.

• Use short date setting: this setting displays dates using the Short Date setting specified in the Regional Settings of your Windows Control Panel. This option is only available when Date is selected.
  

The Print When page allows you to conditionally print an object so it can be ignored under some conditions. It has the following options:

• Print repeated values: setting this to No is like turning on the Suppress repeating values setting for a field in the Field Properties dialog of the Quick Report Wizard: if several records in a row have the same value in this field, only the first occurrence is printed; the field in subsequent records appears blank.

• In first whole band of a new page/column: prints the object in the first band of a new page or column that isn't an overflow from a previous page or column. This option is automatically turned on (and disabled) if you choose Yes for Print repeated values, and optional if you choose No for Print repeated values.

• When this data group expression changes: prints the object when the value of the chosen group changes. This option is available only if a group exists and Print repeated values is No. Choose a group from the list beside this option.

• When band content overflows to new page/column: prints the object when the band overflows to a new page or column. This option is available only if Print repeated values is No.

• Remove line if blank: removes the entire line of the report the object is on if the object is blank and no other object is on the same line.

• Print only when expression is true: an expression to be evaluated before the object prints. If the expression is true, the object is printed; otherwise, it isn't printed. All other options in this dialog except Remove line if blank are disabled if you include an expression. Click the Expression Builder button to display the Expression Builder.
  

The Calculate page allows you to specify how Stonefield Query performs calculations on this field. It has the following options.

• Calculation type: specifies the type of calculation performed.
  • None: no calculations are made on this field.

  • Count: counts the number of times a field is printed per group, page, column, or report (depending on your selection in the Reset based on setting). The calculation is based on the number of times the field occurs, not on the field's value.

  • Sum: computes the sum of the field's values. This option keeps a running total of the values for a group, page, column, or report (depending on your selection in the Reset based on setting).

  • Average: computes the arithmetic mean (average) of the field values within a group, page, column, or report (depending on your selection in the Reset based on setting).

  • Lowest: displays the lowest value that occurred in the field for a group, page, column, or report (depending on your selection in the Reset based on setting).

  • Highest: displays the highest value that occurred in the field for a group, page, column, or report (depending on your selection in the Reset based on setting).

  • Standard deviation: returns the square root of the variance for the field values within a group, page, column, or report (depending on your selection in the Reset based on setting).

  • Variance: measures the degree to which individual field values vary from the average of all the values in the group, page, column, or report (depending on your selection in the Reset based on setting).

• Reset based on: allows you to specify the point at which the calculation is reset to 0. By default, Report is displayed, meaning the calculation retains its value until the end of the report. You can also select Page or Column, indicating that the calculation is reset at the end of each page or column. If there are any groups in the report, this option displays an item for each group. If the report has more than one detail band, this option displays an item for each band.
  

The Other page allows you to specify additional information about a field. It has the following options:

• Comment: displays a comment about the field. To change the comment, click the Edit comment button.

• Report designer caption: the descriptive name displayed in the Advanced Report Designer for this field.

• Tooltip: the text that displays for this field when you hover the mouse over it. This is usually used to display longer descriptive information than the caption. To change the tooltip, click the Edit tooltip button.
  

The Link page allows you to link the selected field to an email dialog, a Web site, or a report. A linked field appears underlined in the report Preview window, similar to a hyperlink in a Web browser, in either blue (for email and Web site links) or green (for report links). See the Field Properties topic for more information on linking and the options in this page.