Report Wizard - Group/Sort

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.

Records in a report are usually organized into groups based on certain criteria.  With the Group tab you can enter the criteria to define multi-level groups.  You can also specify the ordering of groups and ordering of records.

The Sort tab allows you to organize the information within the group by sorting records within the section.


How to use Group/Sort:
To select a criteria for the Group tab, expand the table directory in the Working Set menu by double clicking the table icon or clicking the + icon.  Next, highlight the field you want as a criteria for the grouping.  Lastly, click on the > button to place your criteria in the Group tab.   The same procedure applies for the Sort tab, just make sure the Sort tab is clicked first.   


Ordering your data:
You will notice an up arrow besides each field selected to be grouped.  This means that the fields will be grouped and sorted in ascending order (A, B, C).  Clicking on the up arrow icon changes it to a down arrow.  This means that the fields will be grouped and sorted in a descending order (C, B, A).  The X-icon does not sort your data.  JReport will generate a group break according to original order.


What is the S-icon in the Group Tab?:
The S-icon that is seen beside the fields is a special way to define how to group your information.  Click here for more information on the Specified Options menu.


What is TopN?:
If you click on the TopN box and place a number "N" in menu box, JReport will only display the first N records in the group.