Report Designer expressions and functions

Expressions

When you generate a report, each expression calculates to produce a value. This value can come directly from the database, or be the result of further calculations on the information in the database.

An expression is a formula, ▼ which can include:

Build an expression

1. Select the document you want to amend, then click Edit. For example: 
   • Sage 50 Payroll: Go to Payroll, then Reports
   • Sage 50 Accounts: Go to Invoices and credits, then Reports
2. On the menu bar click Report, then Report Properties.
3. Enter a new report name and description, then select OK.
4. On the menu bar, click Toolbox, then Add Expression.
5. Select the area of the document where you want the new expression to appear.
6. Use the formatting rules when building expressions to create your own expression. Or use one of the common expressions for Sage 50 Accounts or Sage 50 Payroll.
7. Click OK.
8. On the menu bar click File, then Save As.
9. Enter a new file name then select Save.
10. On the menu bar click File, then Exit.

Common Expressions

We've gathered the most common expressions to help you add expressions, for both:

• Common expressions for Sage 50 Accounts reports
• Sage 50 Payroll common expressions 

We've also gathered using dates in expressions on Sage Accounts reports. For example, the age of a transaction or the first day of the financial year.

Snippets

The Expression Editor in Sage Report Designer - Snippets contains a feature you can use to save common expressions and calculations to use in future expressions and filters.

Functions

A Report Designer - Function is a predefined formula that performs calculations using specific values in a particular order.

To help to build expressions, you can use the following ▼ functions and operators:

If statements

In Report Designer - Using If statements in the Expression Editor are being used on a report to say if a certain condition is met. If a condition is met, perform one action; otherwise, perform a different action. You can use an If statement to return certain values depending on the condition specified.