## Customized Function dialog

This dialog appears when you click the Customize item in the Special Function drop-down list in the Group screen of the report wizard, or the New Summary dialog/Edit Summary dialog. Options in the dialog vary according to the data type of the selected group by field.

OK

Accepts all changes and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Help

Displays this help document.

If the group by field is of Numeric type, the dialog appears as follows:

By Intervals

Specifies to group the data by intervals.

- Numerical Value
  Specifies the intervals of the group. It should be an integer value no larger than 255.

Within Range

Specifies to group data within certain range. If this option is checked, you need to enter a value as the range in the Within text box and specify how to apply the range, to increasing data or decreasing data, by selecting the item from the drop-down list.

Keep values outside of the range in special group

Specifies to put values that do not fall within the defined interval or range in a new special group.

- Special Group Name
  Specifies the name for the special group.

If the group by field is of String type, the dialog appears as follows:

First/Last N letters

Specifies the intervals with which to group the report data.

Case sensitive when grouping

If checked, JReport will distinguish between uppercase and lowercase characters when grouping.

Convert group name to

Specifies how to convert the group name. If Case sensitive when grouping is selected, this option will be disabled.

- Uppercase
  Specifies to convert the group names to uppercase.
- Lowercase
  Specifies to convert the group names to lowercase.
- No Conversion
  Specifies not to convert any group names.

Keep values outside of the range in special group

Specifies to put values that do not fall within the defined interval in a new special group.

- Special Group Name
  Specifies the name for the special group.

If the group by field is of Date/Time type, the dialog appears as follows:

Time

Specifies the time which will be applied as the intervals to group data.

The Offset of Time Grouping

Specifies the offset used to grouping the data.

- 1/1/1970 00:00:00
  The default offset defined by JReport.
- Customized Value
  If checked, you can define your required offset by clicking the calendar button.

The First Day of the Week

Specifies which day will be regarded the first day of a week.

Keep values outside of the range in special group

Specifies to put values that do not fall within the defined interval in a new special group.

- Special Group Name
  Specifies the name for the special group.

###### Related topics:

- Specifying special function for group by field