Sage 200 Report Designer - How to amend the thousands separator for numeric values
Description

This article has been prepared and issued to you as a goodwill gesture only and Sage accepts no liability or responsibility for its use. For further support please refer to your Business Partner.

Cause
Resolution
  1. Select the numeric variable > Properties > Formatting > finder button > Numeric tab.
  2. Select the Use custom thousand separator check box > if the thousands separator window doesn't automatically appear, click Edit > ensure the thousands separator box is blank > OK > OK.

    Tip: Alternatively, to add a thousand separator, put the symbol you require into the thousand separator box.

  3. Preview the layout > if the thousands separator still appears > view > designer > double click the variable > copy the variable name > clear > CString(variable name) e.g. CString(SOPInvoiceCreditLines.LineTotalValue).
  4. This will read the value as a word rather then a number the therefore not contain a thousand separator.

If you are viewing this article from the Sage website, a list of Sage 200 Report Designer articles are available now.

 

[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions