Page Comparison

{anchor:top}
{toc: class=contents}
h2. Creating the Minus Sub Query Introduction
{styleclass: Class=topLink}[top|#top]{styleclass}


h2. Initialise
{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%}
!0101create.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%}
!0202builderType.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%}
!2a03view.png|thumbnail,border=1!

{column}
{section}

{section}
{column:width=30%} 
*5.* 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%}
!03option.png!
{column}
{section}
{section}
{column:width=30%}
*6.* Click on the *Sub Query* link. This will open the *Sub Query Type* menu.

*7.* Set the Type to *Minus*.

*8.* Click *Submit*.

*9.* 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%}
!04minus.png|thumbnail,border=1!
{column}
{sectionh2. Master Query
{styleclass: Class=topLink}[top|#top]{styleclass}


h2. Minus Query
{styleclass: Class=topLink}[top|#top]{styleclass}


h2. Save
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column: width=30%}	

*10x.* Drag and drop the !rpt_dim.png! *Athlete ID*, !rpt_dim.png! *First Name*, and !rpt_dim.png! *Last Name* dimensions into the *Column Fields* area. 

*11.* Drag and drop the !rpt_dim.png! *Year* dimension into the *Filters* area.

*12.* Now click on the *Sub Query* tab to setup the sub query fieldsClick *Report* > *Save* to activate your report.
{column}
{column: width=70%}
!05masterxsave.png|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}	

*13x.* SelectSet the *Athlete IDName* fieldof inyour the *Master Query Filter* to nominate it as the field to be filtered in the Master Query by the report to *Minus Sub Query. 
Tutorial*14.*
Select
the *Athlete ID*x.* field inSet the *Link FieldDescription* area to nominate*This itreport aswas the field that provideswritten using the filter values for the *Master Sub Query FilterTutorial*.

*15x.* Drag and drop the !rpt_dim.png! *Year* dimension into the Filters area.

*16.* 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%}
!06subquery.png|thumbnail,border=1!
{column}
{section}
	 

h2. Filtering your Results
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column:width=30%}
*1.* Now to setup the filters. Click on the !rpt_filterprompt.gif! *Filter Prompt* as before as set the *Master Filter* to *2010*. 

*2.* Leave this set to *Equal to* and click on the *Sub Query* tab to set up the other filter.
{column}
{column:width=70%}
!07filterMaster.png!
{column}
{section}
{section}
{column:width=30%}	 
*3.* Set the value to *2010* using the same steps as above, but this time select *Different From* from the drop down list. This will ensure that any records that are not in 2010 are removed from the results.	
Select *Tutorial* as the *Category*.

*x.* Select *Training* as the *Sub Category*.

*x.* Click *Activate* to finish.
{column}
{column:width=70%}
!08filterMinus.png! {column}
{section}
{section}
{column:width=30%}	 
*4.* Your finished report should look like the one pictured here.
{column}
{column:width=70%}
!09minusReport.pngx|thumbnail,border=1!
{column}
{section}
{section}
{column: width=30%}

*5x.* You are now finishedhave with this report. Click on the *Save Menu*.

*6.* Set the *Name* of your report to *an active Minus Sub Query Tutorial*.

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

*8.* Select *Tutorial* as the *Category*.

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

*10.* Click *Save* to finish.
{column}
{column: width=70%}
!10activatex.png|thumbnail,border=1!
{column}
{section}

bq. See
[Filters|Filters] for more information.
\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}