Search HansaManuals.com HansaManuals Home >> Standard ERP >> Report Generator >> Creating a New Report Previous Next Entire Chapter in Printable Form Search This text refers to program version 8.5 Creating a Report Generator Report - Using Variables and Formulae - Joining Two or More Pieces of Information Together This page describes bringing several pieces of information together into a single variable which can then be printed in a Report Generator report. This will improve the appearance and readability of the report as it will allow phrases to be printed in the report without unsightly gaps.--- You can join several pieces of information together in a single variable. This is known as "concatenation". For example, in the Contact Footer section of the example Customer List report that we are using in this documentation, it might improve the appearance of the report if we added the Contact Number or Name to the text "Total for Customer" that is already there. The various pieces of information that you join together must be strings. You can do this using one of two methods:
The code that joins the standard text ("Total for Customer") and the Contact Number is placed in the Contact register section, so it will be used once for each Contact. Whatever was previously in the vsCustText variable will be lost. The code is:
Use the [Formula] button to place the variable in the appropriate section (in this example, in the Invoice Footer section) on the 'Layout' card, in the same way as described on the Printing a Variable page: As with the first method, to join several pieces of information together, place an ampersand between each element. The following example will print the word "Customer:" followed by the Contact Number and Name. A comma and space will be printed between the Number and the Name. The word "Customer:" and the comma and space are both fixed text and are therefore enclosed in inverted commas:
--- Creating a Report Generator Report:
|