BackPrevious Topic Next TopicNext

Customized Function

The Customized Function dialog helps you to define customized special functions. It appears when you select the Customize item in the Special Function drop-down list in the New Summary dialog, Edit Summary dialog, or the Group screen of the report wizard.

The dialog varies according to the different data type of the selected group-by field: Numeric, String, or Date/Time.


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

Customized Function dialog - Numeric

By Intervals

Specifies to group the data by intervals.

  • Numerical Value
    Specifies the intervals of the group.

Within Range

Specifies to group data within certain range. If this option is selected, you need to specify 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. By default, the group name is Others. You can double-click in the text box to rename it.

OK

Accepts all changes and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Help

Displays the help document about this feature.

Back to top


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

Customized Function dialog - String

First/Last N letters

Specifies the intervals with which to group the report data. N should be an integer no larger than 255.

Case sensitive when grouping

If the option is selected, Logi Report 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. By default, the group name is Others. You can double-click in the text box to rename it.

OK

Accepts all changes and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Help

Displays the help document about this feature.

Back to top


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

Customized Function dialog - Date/Time

Time

Specifies the time which will be applied as the intervals to group data. Select the unit of time from the drop-down list to the right of the text box. It could be second, minute, hour, day, week, month, quarter, half year and year.

The Offset of Time Grouping

Specifies the offset used to group the data.

  • 1/1/1970 00:00:00
    The default offset defined by Logi Report.
  • Customized Value
    If the option is selected, you can select the Calendar icon Calendar icon define your required offset using the calendar.

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. By default, the group name is Others. You can double-click in the text box to rename it.

OK

Accepts all changes and closes the dialog.

Cancel

Does not retain any changes and closes the dialog.

Help

Displays the help document about this feature.

Back to top

BackPrevious Topic Next TopicNext