Page History
Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
| ||
HTML |
---|
<iframe width="700" height="394" src="https://www.youtube.com/embed/CyUgmM4PmBI?color=white" frameborder="0" allowfullscreen></iframe> |
Introduction
Styleclass | ||
---|---|---|
| ||
A good way to think about Appends is - use them if you need to add a column to a report that requires filters different to the rest of the report.
In this scenario our main report will look at invoice figures by country in 2014. The column we want to add is the invoiced figures in 2013. The filters Year = 2014 and Year = 2013 conflict, so the additional column will have to be added through the append.
Master Query
The Master Query is going to include:
- Athlete Country
- Sum Invoiced Amount
- Filter: Year = 2014
This will mean that we have Country as a common field for 2014 and 2013 so this will form our join when we add the Append.
Note: sometimes you will have a case where you don't wish to filter the Country list by 2014, this may be because some countries have no results for 2014 yet. In this case you would have Country in the Master Query, and an Append Query for each Invoiced Amount.
Append Query
The Append Query will include:
- Join: Athlete Country
- Sum Invoiced Amount
- Filter: Year = 2013
This will be joined to the Master Query using the Athlete Country field. The query will be filtered by Year = 2013, and will include a copy of the Sum Invoiced Amount field to be filtered.
Create
Styleclass | ||
---|---|---|
| ||
Section | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Master Query
Styleclass | ||
---|---|---|
| ||
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Append Query
Styleclass | ||
---|---|---|
| ||
Create Append
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Join Append
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Filters
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Name & Save
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Add Column
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Edit Settings
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Apply Filters
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Master Filter
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Sub Query Filter
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Formatting
Styleclass | ||
---|---|---|
| ||
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Save
Styleclass | ||
---|---|---|
| ||
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||