Applying Totals

Applying totals summarizes detail rows. The summaries can be applied at group level (in case grouping is applied), page level or report (grand total) level.

Figure 7: Selecting Totals (summary)

Totals properties

Item	Values	Comments
Field	Select from list	Select the field on which the summary needs to be applied
Function	Select from list Sum, Avg Count, Min, Max, Variance, PopVariance, StdDeviation, PopStdDeviation and Distinct functions	Select the function to apply on the summary field. The applicable functions change based on the data type of the summary field. You can view the custom-defined functions in case the functions are defined as discussed under the section “Custom-Defined Functions”.
Level	Group Page Report	Group = Apply and display total at each group level Page = Apply and display total once per page for all detail rows appearing in that page Report = Apply and display grand total at report level

On a summarized report (Report Content = Summarized), only the group Keys and these summaries appear, hiding the detail rows.

In an iHTML grid report you can collapse group keys to show only summary and hide details. You can also expand the group keys to show detail rows.

Note: If total is applied on field that is not in display fields, it will be automatically added in the Display Fields list.

Custom-Defined Functions

You can also use custom-defined summary functions for summarizing data values in reports.

These summary functions can be defined in a class implementing IScriptFunction interface. The .jar file of this class should be placed in ReportEngine > lib folder.
There should also be an .xml file containing all the entries of .jar file and placed in ReportEngine > config folder.

Restart Intellicus Report Server and then Web Server to be able to see these summary functions as any other function in the list. The .xml file would look like:

<SUMMARYPROVIDERS>
	<!-- Summary Provider. Provider name is just a user friendly name to identify provider class.
	Class file is fully qualified java class name of the class containing summary functions.
	A summary provider may have as many summary functions as desired -->
     <SUMMARYPROVIDER PROVIDERNAME="PACKAGECAPTION"
		CLASSFILE="com.client.summaryfunctions.MathAlternate">				        <SUMMARYFUNCTIONS>
			<!-- Summary function that contain logic for applying business logic on the selected field. Name is just a user friendly name that is displayed in the dropdown. Id is a unique number that must be unique and separate from IDs of in-built summary functions.
			Recommended: Start IDs from 1001. APPLYONDATATYPES is a comma-separated list of data types on which this summary function is applicable.
			Possible values are CHAR|NUMBER|DATE. Rest all are ignored  -->
                <SUMMARYFUNCTION NAME="AlternateSum" ID="1001"
				APPLYONDATATYPES="CHAR,NUMBER,DATE">
			</SUMMARYFUNCTION>
			<SUMMARYFUNCTION NAME="ReverseString" ID="1002"
				APPLYONDATATYPES="CHAR">
			</SUMMARYFUNCTION>
			<SUMMARYFUNCTION NAME="ModTen" ID="1003"
				APPLYONDATATYPES="NUMBER">
			</SUMMARYFUNCTION>
			<SUMMARYFUNCTION NAME="FutureDate" ID="1004"
				APPLYONDATATYPES="DATE">
			</SUMMARYFUNCTION>
		 </SUMMARYFUNCTIONS>
	      </SUMMARYPROVIDER>
</SUMMARYPROVIDERS>

Kyvos 2025.1

Applying Totals

Totals properties

Custom-Defined Functions

Related content