Applying Totals

Applies to: Kyvos Reporting

Totals are used to summarize detailed rows in a report and can be applied at different levels—Group, Page, or Report (Grand Total). You can use built-in or custom-defined functions to calculate these summaries.

Tip

If the summary field is not already included in the display, it will be automatically added when a total is applied.

Totals Properties

Property	Description

Property

Description

Field

Select the field on which the summary should be calculated.

Function

Choose a summary function based on the field’s data type. Supported functions include:

Sum
Avg
Count
Min, Max
Variance
PopVariance
StdDeviation, PopStdDeviation
Distinct Count

Custom-defined functions (if configured) will also appear here.

Level

Define the level at which the summary should be displayed:

Group – Shows total for each group
Page – Shows total for all rows on each page
Report – Shows grand total across the report

On summarized reports (when Report Content is set to Summarized), only the group keys and the applied totals are shown. Detail rows are hidden.

In iHTML format, group sections can be collapsed to show only summaries, or expanded to view full details.

Custom-Defined Functions

Kyvos Reporting allows creation of custom summary functions to implement business-specific logic. These functions are added as plug-ins and appear alongside built-in functions.

Steps to Configure Custom Summary Functions

Create a Java Class
Implement the IScriptFunction interface and define your custom logic.
Create a JAR File
Package the compiled class into a .jar file and place it in:
ReportEngine/lib
Define the Functions in XML
Create an .xml file defining the custom functions and place it in:
ReportEngine/config
Restart Servers
Restart the Kyvos Reporting Report Server and Web Server to register new functions.

Sample XML Format

<SUMMARYPROVIDERS>
  <SUMMARYPROVIDER PROVIDERNAME="PACKAGECAPTION"
                   CLASSFILE="com.client.summaryfunctions.MathAlternate">
    <SUMMARYFUNCTIONS>
      <SUMMARYFUNCTION NAME="AlternateSum" ID="1001" APPLYONDATATYPES="CHAR,NUMBER,DATE" />
      <SUMMARYFUNCTION NAME="ReverseString" ID="1002" APPLYONDATATYPES="CHAR" />
      <SUMMARYFUNCTION NAME="ModTen" ID="1003" APPLYONDATATYPES="NUMBER" />
      <SUMMARYFUNCTION NAME="FutureDate" ID="1004" APPLYONDATATYPES="DATE" />
    </SUMMARYFUNCTIONS>
  </SUMMARYPROVIDER>
</SUMMARYPROVIDERS>

Note

Each function must have a unique ID (recommended to start from 1001).
APPLYONDATATYPES defines the data types the function supports: CHAR, NUMBER, DATE.