Specified Option

The S-icon that is seen beside the fields to be grouped is a special way to define how to group your information.



For example, lets say you placed a field named "Region" in the Group tab.  This field contains all 50 states in the United States.  We want to see the data between Maryland (MD) and New York (NY).  In the Special Criteria section we can define this criteria by selecting "between" in the Operator drop down menu and placing MD in the op1 menu and NY in the op2 menu. 

User Defined Grouping Criteria:
To add a new grouping feature, click on the Add button.  This will bring you to the Group Name.  You may create a new name for your grouping criteria.  Next, select an Operator function to group your data.   

There are many other options in the Specified Option section that can define how to group your data.  You can define them by:

• between
• not between
• >    (greater than)
• <    (less than)
• =    (equal to)
• <=  (less than or equal to)
• >=  (greater than or equal to)
• !=    (not equal to)

Either op1 or both op1 and op2 will be seen in the Operand menu.  Place your criteria here.  JReport will automatically place quotation marks on your criteria.  Click on the Add button to add more groupings, the Remove button to delete the current grouping, or the OK button to finish.

Keep values outside of the range in a special group:
By clicking on this box, you allow JReport to keep those values that do not fall in your specified criteria.  These values can be placed in a special group.   Name this group in the Name for the special group menu.