Intellicus Enterprise Reporting and Business Insights 19.0

Importing Parameters

0 views June 28, 2020 0

Parameters stored in the repository can be imported and reused during designing of reports.

Parameters can be imported either by selecting individually or by reference. In case of importing the parameters by reference, if you modify the source parameter at any point of time, this change automatically effects all the reports where the parameter is used.

On the Parameters screen, click Import button. The Import screen appears.

Figure 3: Importing a parameter

Figure 3: Importing a parameter

  1. In Category object selector helps you navigate to folder to list the parameters below.
  2. To select a parameter for import, check the Selected checkbox in corresponding row.
  3. To select a parameter to be imported by reference, select the check box By Ref in the same row.
  4. Click the Apply

Selected parameters are imported to the open report.  Click OK to import the parameters and close the dialog.

Adding Scripts for parameter value validation

You can add a validation script for a parameter. Click Add Script button to open Script Editor screen and write the script.

Figure 4: Adding Script

Figure 4: Adding Script

At parameter level (parameter name will appear in the section), OnChange() event is supported. It means, validation script will be executed when:

  1. User types in a value for the parameter (for input type TEXT), or
  2. Selects/Unselects value from the parameter combo/list/tree.
  3. Checks/ Un-checks a check box.

Validation script written at parameter level can access other report parameters. It can also access parameter objects (even if not imported) and global business parameters. This will be Read-only access.

If the parameter value is valid, script will return ‘True’. If it is invalid, script will return ‘False’. You can set an error message that should be displayed if parameter validation fails. Report will not be generated if parameter validation fails.

Using script, you can modify attributes of parameters. (For example, if paramA is invalid, disable paramB.)  The Parameter Details screen reloads the parameters that are affected by the script.

In case of scheduled report execution, the Parameter Details screen is not displayed. Hence, script will be executed at the time of saving of schedule tasks. Script will not be executed at report run time.

  1. Click Compile to compile the scripts.
  2. Click Ok to save the changes.
  3. Click Cancel to close the screen without making changes.