Content Comparison

{anchor:top}
{toc: class=contents}
h2. Overview
{styleclass: Class=topLink}[top|#top]{styleclass}
The drag and drop report builder providesassists you with an easy to use report creation wizard that assists to create both simple and sophisticated analytical reports.  In this section the The steps required to create a basic report will be covered.  

When you create reports you will be using the report builder wizard which takes you through the steps to create a report.  These steps will be available through the builder are determined by some of the options you choose along the way, including:
* Choosing theThe type of builder toyou use
* SelectingThe thedata source ofyou build dataon
you* wishThe tofields queryyou *use Choosingin the fieldsreport, youand wantthe tolayout havedefined onby your reportthem
* DeterminingThe Filtersfilters and/or sections Sectionsyou *add Choosingto the layout report
* The addition of your Report Related Reports, Drill Functionality, and Sub Queries

\\
Included in the report builder are a number of sectionspossible steps:
# [Initialise ReportCreate|Report Builder#Initialise ReportBuilder#Create]
# [Report SQL|Report Builder#Report SQLBuilder#SQL]
# [Report Data|Report Builder#Report DataBuilder#Data]
# [Report FiltersCharts|Report Builder#Report FiltersBuilder#Charts]
# [Related Reports|Report Builder#Related Reports]
# [Output|Report Builder#Output]


h2. InitialiseCreate Report

{styleclass: Class=topLink}[top|#top]{styleclass}
The first step in building any report is selecting the type of report you wish to run and the data source required.  Your organisation may have many views and data sources so selecting the correct one is critical prior to building your report.

!01reportinit.png|thumbnail,border=1!
bq. See [Initialise Report|Initialise ReportReport Builder - Create Step] for more information.


h2. Report SQL
{styleclass: Class=topLink}[top|#top]{styleclass}
This allows you to define the SQL that the report will be based on, rather than using a Yellowfin view. 
{color: #C00000}*Note:*{color} This step will only be available if the *Freehand SQL* builder option was selected at the *Initialise Report* step.

!02reportSQL.png|thumbnail,border=1!

bq. See [Freehand SQL Reports|Report Builder - SQL Step] for more information.


h2. Report Data
{styleclass: Class=topLink}[top|#top]{styleclass}
The report data section allows you to define the look and feel of your report, including the fields to be displayed, the filters to be used, and whether a chart or drill through should be displayed. Select the items from the view that you wish to include in your report and drag them into the appropriate section of the screen. 

!03reportData.png|thumbnail,border=1!
bq. See [Report Data|Report Builder - Data Step] for more information.


h2. ReportCharts
Filters
{styleclass: Class=topLink}[top|#top]{styleclass}
The filtersCharts page
allows you to set up conditions to return only certain values rather than returning all the data from a selected view. For example, you can specify customer segments for particular organisation units.

!04reportFilters
!04reportFilters.png|thumbnail,border=1!
bq. See [Charts|Report Builder - Charts Step] for more information.


h2. Related Reports
{styleclass: Class=topLink}[top|#top]{styleclass}
One of the major features of Yellowfin is the ability to create drill through reports or display associated reports on the same page. This is done by linking reports together through related reports.

!05reportRelated.png|thumbnail,border=1!
bq. See [Filters|FiltersRelated Reports|Report Builder - Related Reports Step] for more information.


h2. RelatedOutput
Reports
{styleclass: Class=topLink}[top|#top]{styleclass}
One of the major features of Yellowfin is the ability to create drill through reports or display associated reports on the same page. This is done by linking reports together through related reports.

!05reportRelated.png|thumbnail,border=1!
bq. See [Related Reports|Analysis & Related ReportsOutput|Report Builder - Output Step] for more information.
\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}