Report Wizard - Data Tab

In the Report Wizard, the Data tab allows you to select what tables and fields you want to access in the report.

What is the Connection?
Under this section is a listing of all the database files which are accessible through JDBC or ODBC (see Lesson1 for more details).  Double click the database file or click on the + icon to reveal the Tables and Views for each database.  Double click on the Table or click on the + icon to reveal the table fields.  The user may individually select or place all the fields into the Working Set menu by highlighting a specific section and clicking on the arrow button.


What are Queries?
This section includes all the pre-defined queries found the current catalog.  Only one query can be added to the Working Set for the current report.  Double click or click on the + icons to expand this section.  The user may individually select or place all the fields into the Working Set menu by highlighting a specific section and clicking on the arrow button.


What are Formulas?
Formulas are specifically written directions that allow you to create functions for any of the fields selected from Connection or Queries.  In this section, you are allowed to place pre-defined formulas into your report.  The user may individually add the formulas into the Working Set menu by highlighting the specific formula and clicking on the arrow button.


What are Parameters?
Frequently you will need to specify a parameter when running a report.  For example, you may want to input order date as an input parameter when running a report so that only orders on a specific date will be displayed.  Typically, parameters are used as part of the query condition (search criteria) so that only records satisfying that parameter will be retrieved.

Working Set Menu
The Working Set menu is a listing of all the tables and fields you selected from the All Objects menu.  The Working Set can be named in the Query Name menu. The fields and tables selected here can be accessed later in your report by:

• Catalog Browser
• menu command Insert/DBField
• or the DBField icon in the Edit Toolbar
  . 

By placing fields in the Working Set you can later:

• add those fields into your report and display them.
• use specific formulas and summaries that require specific fields.