Overview
The drag and drop report builder provides you with an easy to use report creation wizard that assists to create both simple and sophisticated analytical reports. In this section 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 determined by some of the options you choose along the way, including:
- Choosing the type of builder to use
- Selecting the source of data you wish to query
- Choosing the fields you want to have on your report
- Determining Filters and Sections
- Choosing the layout of your Report
Included in the report builder are a number of sections:
Initialise Report
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.
See Initialise Report for more information.
Report SQL
This allows you to define the SQL that the report will be based on, rather than using a Yellowfin view.
Note: This step will only be available if the Freehand SQL builder option was selected at the Initialise Report step.
See Freehand SQL Reports for more information.
Report Data
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.
See Report Data for more information.
Report Filters
The filters 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.
See Filters for more information.
Related Reports
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.
See Related Reports for more information.