Report Wizard - Query

Report Wizard allows you to quickly create a basic design of the report.  JReport prompts you to define what tables, fields, summaries, and other options are used in a very rough report design.  In this way Report Wizard saves you time in the basic organization and layout of data from the database.

The Query tab shows how multiple tables selected in the Data tab are linked.  This section also allows you to specifically set certain criteria for the fields in the report.

Linking multiple tables:
If you selected multiple tables in the Data tab, JReport will automatically link them together based on the default.  Click here for information on the Auto Join function.

If you wish to manually link the tables together, first select a field from one table.  Next, drag the highlighted field to another table and onto the field that it should link to.  This should create a link that is shown by a green line from one field to another.  You may also want to click on the Arrange button to have JReport arrange the tables into an organized manner where the crossing of green link lines is minimized.

If you want to modify the method of joining two tables, double click the = icon that is located on the green linking lines and the Join Options menu is revealed.  Click here for information on Join Options.

Criteria Menu:
This area allows you to specify what criteria should be used to place data into your report. 


Options Button:
You are allowed to change how Auto Join and other options work in the Query tab.


And Button:
This will take you to the Search Condition window and give you more criteria to further narrow down your fields.


Computed Button:
You can create functions that can be used for a particular query.  This button is convenient because it allows you to quickly and easily create these functions without the hassle of writing formulas.


Arrange Button:
Explained above.