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

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.

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.

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.