i-net Clear Reports

User Defined Formulas

In the reports you can use formulas for complex things. There is also a wide range of functions to do this. But sometime you need more functions that are specific to your application. This is possible by writing these functions in Java yourself. This sample plugin demonstrates how you can do this.

Activate the included plugin

If you want to try this plugin then you need to copy the file customformulas.zip of this sample in the plugins folder of your server or designer installation and restart the server.

To see the effect of the plugin:

  • start the designer (remote or local)
  • edit a formula
  • in the formula editor on the right side expand the tree node “User Defined Functions”
  • expand the tree node “com.inet.samples.formula.FormulaSample”
  • you see a list of functions
  • add one function with a double click to the current formula
  • correct the function parameters
  • run the report.

If you want to write your own formula functions then you simply need to create an instance of com.inet.report.formula.UserDefinedFunction.

Server Plugin

In the next step you write your own server plugin. It must implement the interface com.inet.plugin.ServerPlugin and have an empty public constructor for loading. In the method registerExtension you must register all of your classes. This can look like:

public void registerExtension( ServerPluginManager spm ) {
    spm.register( UserDefinedFunction.class, new MyFunction() );
}

Please refer to the sample com.inet.samples.formula.FormulaSample to see how this is done there.

Build the plugin

The following steps need to be taken if changes are made to the plugin code.

The plugin.properties and server plugin class are preconfigured to be used without modifications. If the sample is the basis for a custom plugin or just needs some adaptions, please refer to the platform programming guide for detailed instructions.

Collect the required jar files

In order to build this plugin the following jar files are required at minimum:

  • inetcore.jar (included in the core directory)
  • ClearReports.jar (included in the core directory)

You can copy these to the current sample directory or link them into the project of your IDE.

Build the plugin

The plugin must be compiled into a jar file that is named like the id of the plugin. In this example it is customformulas.jar. It also must contain the compiled sources as well as required language resources and images.

The target plugin is a zip file, named customformulas.zip in this example. It contains the compiled jar file and the plugin.properties which configures the custom plugin.

The provided build.gradle in the sample can be used to build the plugin as well as any other build system.

Deploying

Copy the ZIP file of the plugin into the plugins directory of the server and restart it. If there are problems, then check the log file of the server for more details. The “Config” logger is used to log plugin registration issues.

 

© Copyright 1996 - 2019, i-net software; All Rights Reserved.