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 25: Applying Total (summary)
|Field||Select from list||Select the field on which the summary function 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
|Render As||Sparkline||Sparkline charts represent a series of values as inline charts on the grid. Refer to the screen below as an example of a Sparkline chart. If user sums up “Transaction Amount” grouped by “State”. Then the Sparkline represents a series of total transaction amount values for each sale date over a period of time.
Render As option is disabled for character type of summary field
An example of a Sparkline chart is shown in the below figure.
Figure 26: Sparkline Chart
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 a ‘summaryfunction.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>