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)
|Field||Select from list||Select the field on which the summary needs to be applied
|Function||Select from list
|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”.
|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.
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>