Calculated fields in the report generator

Follow
In the report generator you can use calculated fields. A calculated field is, as the name describes, a field where you can make different calculations. These calculations can either consist of a field from the "Field List" (one of the database fields) or a calculation generated in the "Expression Editor"

Create a calculated field

  1. Select Field List on the right side of the report generator
  2. You can place the field in the root by right-clicking on CompanyInfo and selecting "Add calculated field"
    1. The field is now placed in the root, along with the other fields.
  3. You can place the field under DebtorInfo, for example, by right-clicking on DebtorInfo and selecting "Add calculated field" and the field will now be placed under the DebtorInfo table.
  4. If you right-click on one of the tables or the calculated field, you can choose to Add, Edit the selected or all calculated fields.

Create an Expression

  1. Right-click on the calculated field and select "Edit Expression..."
  2. The Expression editor opens and here you can write your expression.
    1. To avoid mistakes in the way you write your expression, you can click on the functions and fields you want to use.
  3. Remember to drag the field out on the report to display it.
 

Examples of Expressions

Show backorders on an invoice/delivery note Ordered quantity - Delivered quantity - written as below [QtyOrdered]-[InvoiceQty] Enforce capitalization in e.g. the document name For example, the code below shows invoice with capital letters FAKTURA Upper([Document name]) Space between Proforma and Invoice If you want a space between Proforma and Invoice in Proforma Invoice, it can be written as below Upper(Iif(Contains([Document name], 'Pro'), Concat('Proforma ',Substring([Document name], 8 ) ) , [Document name]) Compound fields If you want to combine two fields into one label, you can use the "Concat" function Concat is used for the fields you want to combine, divided by a , (comma). If you want a space, use '(appostrof) ex. ' ' Below, variant name 1 and variant name 2 are put together in the same field/lab, separated by a space. Concat([DebtorInfo.InventoryTransInvoice.Variant1Name], ' ', [DebtorInfo.InventoryTransInvoice.Variant2Name])