Intellicus Enterprise Reporting and Business Insights 19.1

Totals

0 views June 28, 2020 0

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.

select totals
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>