Page History

...

In this tutorial, we will walk through setting up a Union sub query. A good way to this about Unions is - use them if you need to combine multiple fields into the one column, either from the same or different views or sources.

In this scenario our main report will have a list of invoicing figures by region, we will then use the Union query to display negative cost figures in the same column, and then add sub totals to see the total income for each region.

Master Query

The Master Query is going to include:

1. Camp Region
2. Calculated Field: "Invoiced" text label
3. Sum Invoiced Amount

Union Query

The Union Query will include:

1. Camp Region
2. Calculated Field: "Cost" text label
3. Calculated Field: Sum Cost * -1 (to convert the Cost figures to a negative value)

Initialise

...