Feedback Print

Grid totals

The total fields will be displayed only when the Grid application is using at least one Group By.

Settings

The settings below only can be applied for the Grid totals.

Totals settings.

  • Results in a single line.: This option sets the display of the General Total title and its results in a single line.
    • Example for this option Enabled: with the results in a single line.
    • Example for this option Disabled: without the results in a single line.
  • Display Total : This option indicates in which pages the General Total will be displayed. The options are: On every page, On the last page or Do not display.
  • Group Subtotal : This option defines where the subtotal group by will be displayed.
  • Record Count : This option allows you to view the amount of records by the General Total title.
    • Example for this option Enabled: Record Count.* Example for this option Disabled: Record Count.

Layout settings

Setting of display of the subtotal group.

Layout settings.

  • Label - This field sets the Label for the Group Subtotal.
  • Display - This option sets if the Group Subtotal it will be display.

Select fields

Using the select fields area you can set the total fields ant the total options for each field. The same field can be used more than once in the Grid totals area, just if they are using different summaries types.

To define the fields that will be used for totals, drag them to the area, Grid Totals.

Total fields interface.

Note: The total fields will only be displayed if they are also selected to be displayed within the Grid application module.

When positioning the fields, you must define what summarization will be used, to select that you must click in the combo box and select one of the available options, that will be according to the data type (integer, date, text…).

Summarization options.

The summarization options available are:

  • Sum : Sets a sum of the values for the selected field.
  • Maximum : Displays the highest value identified in the selected field.
  • Minimum : Displays the lowest value identified in the selected field.
  • Average (Avg) : Calculates the arithmetic mean of the values for the selected field.
  • Variance : Calculates the dispersion of the values related to the average.
  • Standard Deviation : Measures the variability of values around the average, the minimum value of the standard deviation is 0 indicating that there is variability, i.e. that all values are equal to the mean.
  • Weighted mean (WAvg) : Calculates the weighted average for the selected field. To set the weight used in the calculation of the average access field settings selected in Totals > Fields (select the field where you are using the Weighted mean) > Weighted average weight.
    • Weighted average weight : Field that will be used as weighted average weight. In calculating the weighted average, each set value is multiplied by its “weight”, that is its relative importance.
  • Count : Displays the total number of records for the selected field.
  • Distinct Count : Displays the total number of records for the selected field, distinguishing the values.

Important note: The fields in the Grid totals are displayed only on Grids with no Group by or with empty Group by.

Positioning

Defines the positioning and the label used by Grid totals. There are three display formats,, Default, Grouped or By field

Default

To add the same field two or more times in the Totals or use different types of summaries in selected fields, this option will not be displayed.

The option Default returns the result below the column being summarized. When you use the total for more than one column of the Grid, using the same type of summarization, the results are displayed on the same line.

Interface of fields sorting for the option "Default".

The line with General Total displaying the Sales.

Default sorting within a final application.

Alignment

This option is available for display formats Default and Grouped.

Defines the placement of the label selected within the Setting > Display total option. The alignment can be in the Center, Left e Right:

  • Left : Alignment in the final application.
  • Right : Alignment in the final application.
  • Center : Alignment in the final application.

Label settings (Default)

This option allow you to customize the total labels.

As default we are going to display Grant total

Label value settings.

Grouped

The option Grouped returns the total result, separating each type per line.

It is possible to position the total lines by dragging to the desired position.

Changing the lines placement.

In this example, we are displaying the sum, average, maximum and minimum of column Sales.

Grouped totals within the final application.

Alignment

This option is available for display formats Default and Grouped.

Defines the placement of the label selected within the Setting > Display total option. The alignment can be in the Center, Left e Right:

  • Left : Alignment in the final application.
  • Right : Alignment in the final application.
  • Center : Alignment in the final application.

Label settings (Grouped)

This option allow you to customize the total labels.

Label settings.

By field

This option displays the values in the left corner by positioning the results next to each other.

Interface of fields sorting for the option "By field".

Line break per field

This option sets the total fields display. If selected it shows the fields in the same row or divided by line.

Separated by line:

Final application with the option "Line break per field" enabled.

Displayed on the same line:

Final application with the option "Line break per field" disabled.

Label settings (By field)

This option allow you to customize the total labels.

Label settings.

Fields

This option allows you to configure the display of values and labels of the selected fields in the Grid totals.

General Settings

Allows you to change the label displayed in the totals

Label editing.

Visual configuration for the Grid totals

Sets the formatting of the fields displayed in the subtotal for the group.

Totals setting options

  • Font family : Sets the font used.
  • Font size : Sets the font size.
  • Text color : Sets the text color
  • Background color : Sets the background color.
  • Bold : Format text in bold.

Example of formatting the subtotal for the Group:

Preview of the label in the generated application

General Total Visual setting

Sets the formatting of the fields displayed in the General total.

Grand Total line configuration interface.

  • Font family : Sets the font used.
  • Font size : Sets the font size.
  • Text color : Sets the text color
  • Background color : Sets the background color.
  • Bold : Format text in bold.

Example of formatting the Grid General Total

Preview of the label in the generated application