Page History
...
Styleclass | ||
---|---|---|
| ||
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:
- Camp Region
- Calculated Field: "Invoiced" text label
- Sum Invoiced Amount
Union Query
The Union Query will include:
- Camp Region
- Calculated Field: "Cost" text label
- Calculated Field: Sum Cost * -1 (to convert the Cost figures to a negative value)
Initialise
Styleclass | ||
---|---|---|
| ||
...