Page Comparison

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

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

{section}
{column: width=30%}
*3.* Select *Ski TutorialTeam* as the Source System and Database View (if not already selected).

*4.* Now click either of the !step_right_on.png! buttonsbutton to proceed.	
{column}
{column: width=70%}
!02initialise2a.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}
{section}
{section}
{column:width=30%}	 
*10.* 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 fields.
{column}
{column:width=70%}
!05master.png|thumbnail,border=1!
{column}
{section}
{section}
{column:width=30%}	 
*13.* Select the *Athlete ID* field in the *Master Query Filter* to nominate it as the field to be filtered in the Master Query by the Sub Query.

*14.* Select the *Athlete ID* field in the *Link Field* area to nominate it as the field that provides the filter values for the *Master Query Filter*.

*15.* 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.	
{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.png|thumbnail,border=1!
{column}
{section}
{section}
{column:width=30%} 
*5.* You are now finished with this report. Click on the *Save Menu*.

*6.* Set the *Name* of your report to *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%}
!10activate.png|thumbnail,border=1!
{column}
{section}

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