Skip to content
logo Knowledgebase

Report Designer - Numeric formatting

Created on  | Last modified on 


Any numeric variable or expression has particular properties that affect how it appears on a document. These properties can be changed, if required.


For example, you might want to change the number of decimal places displayed, or the format in which a date appears.


Alter the numeric properties of an object

  1. Select the document you want to amend, then click Edit.
  2. On the menu bar click Report, click Report Properties.
  3. Enter a new report name and description, then click OK.
  4. Select the numerical object, then in the Properties pane select the Formatting option (You might need to click View and then Properties depending on your current configuration). 
  5. Click the finder button and make your changes.
  6. Click OK.
  7. On the menu bar click File, click Save As.
  8. Enter a new file name then click Save.
  9. On the menu bar click File, then click Ex.


Provides options governing the style and format of the numeric object. The following options are available:


Style This option changes the output so that either values, words or a logical yes or no option appears.

Suppress if zero To suppress the numeric variable if it has a value of zero, select this check box. The line containing the zero value prints, but there is a blank space where the zero value would have appeared.
Display leading zero You can use this option to suppress values starting with zeros.

Maximum and Minimum decimal places

Change the maximum and minimum number of decimal places for a number.


From the drop-down list, choose how you want to display the numeric object.


From the drop-down list, choose the part of the numeric value to be displayed. The default is set to Whole, so that the whole of the numeric value appears. This function is commonly used for cheque printing.

Show DR/CR for negative numbers To display the numeric value prefixed with either DR or CR, depending on whether the value is a debit or a credit, select this option.

Show as currency

To display a currency symbol against the values, select this check box.  

NOTE: Selecting this option will always show the currency symbol of your PC's region.

Use custom thousand separator

To display a thousands separator that is different from the Windows default, select this check box. Enter the required thousands separator symbol, then click OK.

NOTE: To show a currency value without a thousand separator, you can tick this option then delete the comma from the edit option.

Preview This displays a preview field into which you can enter a value. This allows you to see the effects that amending the numeric options would have on this value.

Fill Format

Provides options governing the fill format which applies to the numeric object. The following options are available:

Fill format

You can use this to enter a fill format against numbers, for example on cheques for security purposes. From the drop-down list, choose from the following options:

  • Pre-fill - posts characters before a value appears
  • Post-fill - posts characters after a value appears
  • Surround - posts characters both before and after a value appears
  • Secure cheque - enhanced security fill mode which features two fill characters to the left of the value and fully fills the rest of the variable.

Fill length

Applies if you choose Pre-fill, Post-fill or Surround from the Fill format drop-down menu.

Fill all available spaces - To fill all of the available space with fill characters, select this check box.

Characters - If you don't select Fill all available spaces, in here you can enter the number of fill characters to be used.

Characters If the fill length is not selected, enter the number of fill characters to be used here.

Fill character Specify the character to be used in the fill.



Transform the way you do HR

Track, manage, and engage your employees from anywhere as easily as you do in the office.

Find out more