Content Comparison

{anchor:top}
h2. Creating the Append Sub Query
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*1.* Click on the *Create* link and select *Report* to begin building your report.
{column}
{column: width=70%}
!01.png! 
{column}
{section}

{section}
{column: width=30%}
*2.* You should now be on the Initialise Report page. Select the *Drag and Drop Builder* as the build tool.
{column}
{column: width=70%}
!02.png! 
{column}
{section}

{section}
{column: width=30%}
*3.* Select *Ski Team* as the View.

*4.* Now click the !step_right_on.png! button to proceed.
{column}
{column: width=70%}
!2a.png|thumbnail,border=1! 
{column}
{section}

{section}
{column: width=30%}
*5.* Tick the checkbox next to !subquery.gif! *Sub Queries* to enable them. There should now be a *Sub Query* link at the top of the page.
{column}
{column: width=70%}
!03subqueryOption.png!
{column}
{section}
{section}
{column: width=30%}
*6.* Drag and drop the !rpt_dim.png! *Athelte Country* dimension and !rpt_metric.png! *Invoiced Amount* metric into the *Column Fields* area. 

*7.* Drag and drop the !rpt_dim.png! *Year* dimension into the *Filters* area.
{column}
{column: width=70%}
!04master.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*8.* Click on the + *Sub Query* link. This will open the *Sub Query Type* menu.

*9.* Set the Type to *Append*, leaving the Style set to *Basic* for now.

*10.* Click *Submit*.	 
{column}
{column: width=70%}
!05subquerySelection.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*11.* Now drag in the same fields as the master query. The difference between the two queries will be set up using filter values.
{column}
{column: width=70%}
!06subquery.png|thumbnail,border=1!
{column}
{section}


h2. Joining your data together
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*1.* Click on the Refresh link in the *Joins* area (on the sub query tab) to load the child fields you just added.
{column}
{column: width=70%}
!07refresh.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*2.* Set both the *Master* and *Child* fields to *Athlete Country*, select a join operand, and click the {color:#357CB6}Add Join{color} button to save.	 
{column}
{column: width=70%}
!08addJoin.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*3.* You should now have a join that looks like the one pictured.

*4.* Click on the !step_right_on.png! at the top of the page to progress to the next step (filters).	
{column}
{column: width=70%}
!09joined.png|thumbnail,border=1!
{column}
{section}


h2. Filtering each query
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*1.* To set the *Master Query Filter* click on the !rpt_filterprompt.gif! *Filter Prompt* image. This will load a list of filter values.
{column}
{column: width=70%}
!10filterMaster.png!
{column}
{section}
{section}
{column: width=30%}
*2.* In the *Filter Values* window select *2010* and click on the *Submit* link to load the filter.
{column}
{column: width=70%}
!11values.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*3.* You should now have the *Master Query Filter* set, as shown here.	 
{column}
{column: width=70%}
!12filterMaster.png!
{column}
{section}
{section}
{column: width=30%}
*4.* To set the *Sub Query Filter*, follow the same steps as above, this time selecting *2009* as the value.

*5.* You can now click on the !step_right_on.png! at the top of the page to view your report.	
{column}
{column: width=70%}
!13filterSubquery.png!
{column}
{section}
bq. See [Filters|Filtersフィルター] for more information.

h2. Customisation
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*1.* You should now have a report that looks like the one pictured here. To make it easier to read you are going add some formatting to it.	 
{column}
{column: width=70%}
!14report.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*2.* Click on the *Columns* link at the top of the page.
{column}
{column: width=70%}
!15column.png!
{column}
{section}
{section}
{column: width=30%}
*3.* Select the *Sum Invoiced Amount* Column from the dropdown.
{column}
{column: width=70%}
!16format.png!
{column}
{section}
{section}
{column: width=30%}
*4.* Click on the *Display* Menu.

*5.* Change the *Display Name* to *Invoiced 2010*.

*6.* Click on Close.

*7.* Repeat these steps for the *Sub Query: Sum Invoiced Amount* column, this time setting the *Display Name* to *Invoiced 2009*.
{column}
{column: width=70%}
!17columnDisplay.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*8.* You should now have a report that looks like the one pictured here. The columns are clearly labelled to make it easier to read the data.
{column}
{column: width=70%}
!18formattedReport.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*9.* You are now finished with this report. Click on the *Report Menu* and select *Save*.

*10.* Set the *Name* of your report to *Append Sub Query Tutorial*.

*11.* Set the *Description* to *This report was written using the Sub Query Tutorial*.

*12.* Select *Tutorial* as the *Category*.

*13.* Select *Advanced Reporting* as the *Sub Category*.

*14.* Click *Save* to finish.
{column}
{column: width=70%}
!19save.png|thumbnail,border=1!
{column}
{section}
bq. See [Formatting|Formatting] for more information.
\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}