Sage 200 Report Designer - Using + to combine values into one field

Summary

Sometimes it may be necessary to merge combinations of text and numbers into one field in Report Designer to make alignment easier. For example you may want to combine the word Tel: and the SLCustomerAccounts.ContactTelephoneNumber variable into one field. You can do this by adding an expression and using the plus sign + to join values together. This article provides examples of how you can combine different values into one field using +.

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.

Resolution

NOTE: Note: You can only combine string fields using the +, therefore numeric fields must be converted to strings using the Cstring function. Read more >

 

Examples

The following table shows the output if the following expressions were created:

Expression Example output

"Tel: " + SLCustomerAccounts.ContactTelephoneNumber

 Tel: 0800 111 5555
"Inv No: " + CString(SOPInvoiceCredits.DocumentNo) Inv No: 1
SLCustomerAccounts.CustomerAccountNumber+ " " + SLCustomerAccounts.CustomerAccountName A1D001 A1 Design Services
"Payment is due on " + DateTimeToFormattedString(SOPInvoiceCredits.DocumentDate + SOPInvoiceCredits.DocumentDate,"dd/MM/yyyy") + "." Payment is due on 01/01/20015.
SYSCurrencies.Symbol+ "" + FormatString ("{0:N2}", SOPInvoiceCreditLines.LineTotalValue)

£1000.00

NOTE: This expression forces the amount to display with two decimal places. If the CString function is used instead, zero value decimal places do not appear and the above value would display as £1000.

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.

Image

Solution Properties

Solution ID
200427112323576
Last Modified Date
Wed Mar 23 14:25:27 UTC 2022
Attributes
Product Details
Modules: Sales
Modules: Point of Sale
Modules: Order Entry
Modules: Purchases
Modules: Suppliers
Modules: Tax
Modules: VAT
Modules: Bank feeds
Modules: Payroll solutions
Modules: Bank Manager
Modules: Customers
Modules: Contact Management
Modules: Inventory Optimization
Modules: Project accounting
Modules: Bookkeeping for clients
Modules: Customer information
Modules: Report Writer
Views
0