Report Wizard - Cross Tab

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.

A Cross Tab is a report that summarizes data and presents the summaries in a compact row and column format.  This allows comparisons and identification of trends to be displayed.

This is an example of a typical cross tab report.

Getting Started:

After completing all the necessary information in the Data and Query tabs, CrossTab specifications can be filled in using the table shown below.  This is the Cross Tab Report Wizard window under the CrossTab tab.
         

Highlight a specific field from the query you created in the Data tab.  Either click on Add To Row, Add To Column, or Add To Summary.  If you selected Add To Summary, do not forget to select a function from the Function drop menu on the right.  You may remove unwanted fields by highlighting them and clicking on Remove.

Highlight a field in the Rows or Columns boxes to set its group options with the Group Options button.  You can also set its background color with the Background button.

If there is more than one field in the Rows, Columns, or Summarized Fields boxes, you can click to alter the sequence.