Previous Topic  Next Topic

Using Dynamic Resources

When you drag view elements from the Resource View panel to analyze data of a report, sometimes you may find that the view elements that have been predefined in the business view cannot meet your requirements, in which case you can create dynamic resources including formulas and aggregations and use them in the report to get the desired data. Then when you save the report, the dynamic resources will be saved along with the report as its resources.

Dynamic resources are report tab level resources, which means they are only available to the report tab for which they are created.

A Logi JReport Live license for Logi JReport Server is required in order to use this feature. If you do not have the license, contact your Logi Analytics account manager to obtain it.

Below is a list of the sections covered in this topic:

• Creating and Using Dynamic Formulas
• Using User-Defined Functions
• Creating and Using Dynamic Aggregation Objects

Creating and Using Dynamic Formulas

You should have some knowledge of the formula syntax before you can successfully compose a formula with no errors. To learn the formula syntax, see Formulas in the Logi JReport Designer User's Guide.

To create a dynamic formula:

1. In the Resource View panel, expand the Dynamic Resources > Formulas node, then select <Add Formula…>. The Formula Editor appears.

   

2. Enter a name for the formula in Formula Name text box.
3. By default, Logi JReport will decide whether the formula can be used as an aggregation object, and if not, the formula will be used as a detail object. You can specify to use the formula as a detail, group, or an aggregation object, by selecting the corresponding view element type from the Use As drop-down list on the toolbar.

   Whether a dynamic formula can be used as a certain type depends on the following rules:

   • Any formula can be used as Detail.
   • Any formula that references a DBField and not an aggregation can be used as Group.
   • A formula that refers only to aggregations can be used as Aggregation. For example, there are two aggregations Sum_Total and Sum_Quantity, and you can create a formula @"Sum_Total" / @"Sum_Quantity" and use it as an aggregation.
   • A formula that follows the custom aggregation expression can be used as Aggregation.
4. Compose the formula by selecting the required fields, functions including Logi JReport built-in functions and user-defined functions, and operators from the Fields, Functions and Operators boxes respectively. You can also write the formula by yourself in the editing box.
5. Select the Check button to check whether or not the syntax of your formula is correct.
6. Select the OK button to create the formula.

Once a dynamic formula is created, you can then drag it from the Resource View panel to the desired position in the report for data analyzing. The formulas can also be used to control object properties if you are an advanced user and provided that the Use Dynamic Formula in Property is checked on the Report menu.

If you want to further edit an existing dynamic formula, remove any that is not required, or change the formula type as Group, Detail, or Aggregation if possible, right-click the formula and then select the corresponding command on the shortcut menu. Dynamic formulas that have been used in the report cannot be deleted.

Using User-Defined Functions

When you create dynamic formulas to use in a report, if the built-in functions do not satisfy your requirements, you can make use of the User-Defined Function feature to create any functions as you want. Then when you save the report tab, the functions will be saved into the report tab as its resources the same as dynamic formulas. User-defined functions can also call other user-defined functions.

To create a user-defined function:

1. In the Resource View panel, expand the Dynamic Resources > User-Defined Functions node, then select <Add Function…>. The User-Defined Function Editor appears.

   

2. Enter a name for the function in the Function Name text box.
3. Compose the function by double-clicking the required fields, functions including Logi JReport built-in functions and other user-defined functions, and operators from the Fields, Functions and Operators boxes respectively. You can also write the function by yourself in the editing box.

   The function syntax is as follows:

   arguments: VariableType1 VariableName1, VariableType2 VariableName2, ...;

   For example, arguments: integer age, string name;

   An argument works the same as a local variable except that it is not allowed to assign any value to it, like arguments: integer age=10;.

   See also Formula Syntax in the Logi JReport Designer User's Guide for information about the syntax.

4. Select the Check button to check whether or not the syntax of your function is correct.
5. Select the OK button to create the function.

   The function is then available under the User-Defined Functions node in the Functions box of the Formula Editor and User-Defined Function Editor. You can call it in a dynamic formula or another user-defined function by double-clicking it.

Suppose a user-defined function named function1 is written as: arguments: integer age, string name;, you can call it as follows:

• @function1(25, "John Smith");
• @'function1'(25, "John Smith");
• @"function1"(25, "John Smith");

If you want to further edit an existing user-defined function or remove any that is not required, right-click the function in the Resource View panel and then select the corresponding command on the shortcut menu. Functions that have been used in the report cannot be deleted.

Creating and Using Dynamic Aggregation Objects

In Page Report Studio, you can also create dynamic aggregation objects by mapping them to the available resources which include group objects, detail objects in the current business view and the dynamic formulas that have been created in the report.

To create a dynamic aggregation object:

1. In the Resource View panel, expand the Dynamic Resources > Aggregations node, then select <Add Aggregation…>. The Add Aggregation dialog appears.

   

2. In the Aggregation Name text box, specify the display name of the aggregation object.
3. Select next to the Mapping Name text box. In the Select Source dialog, specify a field or a formula on which the aggregation object is based.

   

4. From the Aggregate Function drop-down list, specify the aggregate function for the aggregation object. When DistinctSum is selected, you should select next to the Distinct On text box to specify one or more group and detail objects according to whose unique values to calculate DistinctSumin using the Select Fields dialog.

   For the usage about each function, refer to Summary functions in the Logi JReport Designer User's Guide.

5. When done, select OK to create the aggregation object.

You can also create a dynamic aggregation object on a dynamic formula. To do this:

1. In the Resource View panel, right-click the formula in the Dynamic Resources > Formulas node, then select Add Aggregation from the shortcut menu.
2. In the Add Aggregation dialog, specify the display name of the aggregation object and the aggregate function as required.
3. When done, select OK.

Once a dynamic aggregation object is created, you can then drag it from the Resource View panel to the desired position in the report for data analyzing.

For any dynamic aggregation object, you can further modify if needed. To do this, right-click the aggregation object and select Edit from the shortcut menu. Then in the Edit Aggregation dialog, edit the aggregation object as required.

For dynamic aggregation objects that are on longer required, you can remove them. To delete an aggregation object, right-click it and select Delete on the shortcut menu. Aggregation objects that have been used in the report cannot be deleted.

Previous Topic  Next Topic