 NOTE: Note: You can only combine string fields using the +, therefore numeric fields must be converted to strings using the Cstring function. Read more >
ExamplesThe 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. [BCB:19:UK - Sales message :ECB] |