Group/Sort

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 Insert Group/Sort

• Catalog Browser: Click on the icon in the Container tab.
  
  
• Edit Toolbar: Click on the icon
  
  
• Menu: Click on Insert/Group/Sort...
  
  

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 to be as a criteria for the grouping.  Finally, click on the > button to place your criteria in the Group tab.  The same procedure applies to the Sort tab.   


Ordering your data
You will notice that besides each field that is placed in the tabs,there is an up arrow.  This means that the fields will be grouped and sorted in an ascending order (A, B, C).  You can change an up arrow to a down arrow by clicking on the up arrow icon.  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 which is seen beside the fields is a special way to define how to group your information.   Click here for more information.


What is the Sort Option button?
If you highlight a field in the Group tab which has been used in a summary function, the Sort Option feature is available.  Click here for more information.


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.