Formatting number fields

  1. To format a number field, highlight the required field on the Report Layout window. Right-click and select Format > Number, or from the data fields window click the Query button next to the Format row.
  2. The TextBox Properties dialog is displayed. Select the Number tab.
  3. Select the required Format Specifier from the following options: Number, Fixed, Currency, Sentence, Word, or Custom. Enter any further information required as follows:

    Use this format to numbers.

    Decimal Places
    Specify the number of decimal places required.
    Use Default
    Check this check box to use the default number of decimal places. If the number exceeds the size of this field, it is filled with '*' asterisks.
    Example
    An example is shown of how the number will appear on the report.

    Use this format to fixed numbers.

    Decimal Places
    Specify the number of decimal places required.
    Use Default
    Check this check box to use the default number of decimal places. If the number exceeds the size of this field, it is filled with '*' asterisks.
    Example
    An example is shown of how the number will appear on the report.

    Use this format to currency.

    Decimal Places
    Specify the number of decimal places required.
    Use Default
    Check this check box to use the default number of decimal places. If the number exceeds the size of this field, it is filled with '*' asterisks.

    Use this format to currency codes.

    System Defined
    Use one of the system level currencies as the currency. For example, base currency or report currency.
    Note: When the field is of money type the system defined currency is automatically assigned and this option is disabled.
    User Defined
    Use one of the currencies defined in the currency file.
    Display Code
    Check this check box to display the currency code within this field.
    Hash Value
    Use the entered string as the '#' hash currency code when printing totals of mixed currencies. That is, this is the unit of measure currency code that will be printed when transaction amounts are added together that are in a mix of currencies.
    Note: This cannot be used when totals are printed on Page Headers/Footers or repeated group sections.
    Example
    An example is shown of how the number will appear on the report.

    Use this format to convert a number to a sentence.

    Decimal Places
    Specify the number of decimal places required.
    Use Default
    Check this check box to use the default number of decimal places
    Language
    Specify the language the report will be displayed in.
    Currency
    Specify the currency to be used. For example, GBP for British Pounds Sterling.
    Name Indicator
    Select from the following options:
    • No subunit
    • Use subunit
    • Use subunit and denominator
    • Subunit to sentence.
    'And' Indicator
    Select the option you require from the drop-down list:
    • All languages - include lower level and higher level 'And'.
    • All languages - exclude lower level and higher level 'And'.
    • All languages - exclude the lower level 'And' or language equivalent.
    • English only - exclude the higher level 'And'.
    • English only - exclude both the lower level and higher level 'And'.
    • Spanish only - use 'Con' as opposed to 'Y' for lower level 'And'.
    Edit Lines Detail
    Click this button to display the Setup Lines dialog.
    Line 1 - 4
    Adjust the following fields as required:
    • Line Length
    • Alignment
    • Before Spacing
    • After Spacing
    Example
    An example is shown of how the number will appear on the report.
    Note: When using the sentence format ensure that the text box size is large enough to contain the full width and height defined.

    Use the Word format to translate a single digit of the number.

    • Language
    • Numbers to Words
    • Example String

      An example is shown of how the number will appear on the report.

    Custom

    Use the '0' or '#' hash character placeholder to define a format style and use the full stop and comma to indicate the decimal and thousand separators. The actual separators output will be determined by the locale.

    Format
    Examples:
    • 00000 will output 1234
    • 0.00 will output 12.34 in UK or 12,34 in Germany
    • #,###.## will output 1,234.56 or 1.234,56
    Note: The use of full stops and commas in the format string are only indicators of the decimal and thousand separators. The actual separators used are determined by the locale.
  4. Save your changes.