Q: Variables (data fields)

Right-click the variable and choose Copy, then right-click then choose Paste.

Select the variable then press Delete.

1. Right-click a blank section of your toolbar.

   The Toolbar menu appears.

2. Click Variable.

   Drop-down lists of available tables and variables appear.

3. Choose a table and variable from the drop-down lists.
4. Click on Insert.

5. Click and drag on your report to draw where you want to place the variable.

   Alternatively, click once on your report where you want to insert your variable. Then select  Pointer from the toolbar. You can now move, resize and amend your variable.

Some variables use numbers that have a particular meaning, for example, 1 may represent 'true' and 0 'false'. These variables are referred to as coded variables.

To display a variable using its description:

1. Select the variable.
2. From the Properties pane, click the Display Named Values drop-down list and select Readable Value.

For examples of coded variables, see:

• Sage 50 Accounts example: Coded variables.
• Sage 50 Payroll example: Coded variables.

Add the PAGE variable from the REPORT table.

You might be inadvertently joining to a table which contains detail records (for example, the items on an order) when you only want to report on the header record (for example, the order itself). As the detail records all relate to the same header record, the variables in the header table all have the same value for each row in the detail table.