Page Comparison

{anchor:top}
h2. Creating the Union 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.* Drag and drop the !rpt_dim.png! *Athlete Country* dimension and !rpt_metric.png! *Invoiced Amount* metric into the *Column Fields* area. 	 
{column}
{column: width=70%}
!06master.png|thumbnail,border=1!
{column}
{section}

{section}
{column: width=30%}
*6.* Tick the checkbox next to *Sub Queries* to enable them. There should now be a *Sub Query* link at the top of the page.	 
{column}
{column: width=70%}
!03enable.png!
{column}
{section}
{section}
{column: width=30%}
*67.* Click on the *Sub Query* link. This will open the *Sub Query Type* menu.

*78.* Set the Type to *Union*.

*89.* Click *Submit*.
{column}
{column: width=70%}
!04select.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*910.* You should now have a *Master Query* Tab and a *Sub Query* Tab. Click on the *Master Query* tab to setup the query.	 
{column}
{column: width=70%}
!05tabs.png!
{column}
{section}



h2h3. Creating a Field Label
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}
*1.* Drag and drop the !rpt_dim.png! *Athlete Country* dimension and !rpt_metric.png! *Invoiced Amount* metric into the *Column Fields* area. 	 
{column}
{column: width=70%}
!06master.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*2.*11.* Click on the *Add Calculated Fields* Link at the bottom of the page to begin creating a calculated field.	 
{column}
{column: width=70%}
!07calcfield.png!
{column}
{section}
{section}
{column: width=30%}
*312.* Type *Invoiced Amount* in the textbox as shown.

*413.* Click on the !calc_adobj.gif! button to add the text to your formula.

*514.* *'Invoiced Amount'* should now appear in the large text area. This will mean that the calculated field's value will be constant, used as a label in the report.

*615.* Set the *Calculated Field Name* to *Label*.

*716.* Click the {color:#357CB6}Save{color} link to finish.
{column}
{column: width=70%}
!08label.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*817.* Drag and drop the !rpt_dim.png! *Label* Calculated Field into the *Column Fields* area.

*918.* Click on the *Union* tab.	 
{column}
{column: width=70%}
!09master.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*1019.* Drag and drop the !rpt_dim.png! *Athlete Country* dimension and !rpt_metric.png! *Profit Margin* metric into the *Child Fields* area as shown. It is important to make sure the order matches up to the *Master Fields* so that the union works.	 
{column}
{column: width=70%}
!11subquery.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*1120.* Click on the *Add Calculated Field* link as before. This time type *Profit Margin* and click !calc_adobj.gif! to add the text.

*1221.* Set the *Calculated Field Name* to *Label*..

*1322.* Click the {color:#357CB6}Save{color} link to finish.	
{column}
{column: width=70%}
!10label.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*1423.* Drag and drop the !rpt_dim.png! *Label* Calculated Field into the *Child Fields* area as shown.

*1524.* You can now click on the !step_right_on.png! at the top of the page to progress to the next step.	 
{column}
{column: width=70%}
!12subqueryLabel.png!
{column}
{section}


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. 

*2.* To start, click on the *Label* column header and drag it so that it is moved between the *Athlete County* and *Sum Invoiced Amount* columns.	 
{column}
{column: width=70%}
!13reorder.png!
{column}
{section}
{section}
{column: width=30%}
*3.* Your report should now appear as pictured. Reordering the columns should make the information easier to read. Formatting will also help.	 
{column}
{column: width=70%}
!14report.png!
{column}
{section}
{section}
{column: width=30%}
*4.* Click on the *Columns* link at the top of the page.	
{column}
{column: width=70%}
!15columns.png!
{column}
{section}
{section}
{column: width=30%}
*5.* Select the *Sum Invoiced Amount* Column from the dropdown.
{column}
{column: width=70%}
!15column.png!
{column}
{section}
{section}
{column: width=30%}
*6.* Click on the *Display* Menu.

*7.* Change the *Display Name* to *Amount*.

*8.* Click on Close.	
{column}
{column: width=70%}
!16display.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}
*9.* You should now have a report that looks like the one pictured here. 
{column}
{column: width=70%}
!17report.png!
{column}
{section}
{section}
{column: width=30%}
*10.* You are now finished with this report. Click on the *Save Menu*.

*11.* Set the *Name* of your report to *Union Sub Query Tutorial*.

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

*13.* Select *Tutorial* as the *Category*.

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

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