Using Formulas to Control Object Properties

How to set a formula as the property value

Using formulas to control showing or hiding objects in a web report or library component

Example: Changing the banded panel background color at runtime

One of the most useful features of formulas is that you can use them to control the property values of objects at runtime. This provides you much more control, allowing you to customize your report and have flexibility to control the way objects are displayed based on the returned values.

How to set a formula as the property value

While editing the property values of an object in the Report Inspector, when you click on some properties you may notice that a button appears on the right of the drop-down arrow in the value cell. The button can also be seen next to the value text boxes in some dialogs (for example, the Display Type dialog, some chart format dialogs). For such Report Inspector properties and dialog options, you can use formulas to control their values.

To set a formula as the value of a property, click the button and it changes to another button . Click the drop-down arrow in the value cell and a drop-down list is displayed. You can then select an existing formula in the list or click the <New Formula...> item to create one to use for the property. For a crosstab in a query based page report, if you have created crosstab formulas in the crosstab, they are also available in the drop-down list. You can also click the <New Crosstab Formula...> item in the drop-down list to create one to use in the crosstab as well.

In addition, for properties of this type in the Report Inspector, besides using formulas you can edit expressions via the Formula Editor to control their values by clicking the <Edit Expression> item in the drop-down list. An expression is in fact a formula that is local to this report and is not stored in the catalog. When an expression is specified as the value of a property, the expression result will be displayed in the value cell. It is best to use expressions whenever possible to save space in your catalog; however if the formula is needed by several reports then use a formula rather than an expression.

Notes:

When you compose a new formula to control a property, make sure the data type of its return value is the same as the value type of the property. Otherwise, the new formula will not be added as value of the property, although it will still be created in the current catalog or for the current web report/library component.
You cannot use formulas to control object properties in the Report Inspector for page reports creating using business views.

Using formulas to control showing or hiding objects in a web report or library component

In a web report or library component, only the Invisible property can be controlled by formulas in the Report Inspector. However for any object whose parent doesn't have a business view, for example, a label in the tabular cell of a web report, if you want to use a formula to control its Invisible property, you need to first bind a business view to the web report or library component, then you can create dynamic formulas of Boolean type based on this business view to control the property.

Click Report > Bind Data. The Bind Data dialog appears.
Select a business view in the current catalog.
Click OK to bind the business view to the web report or library component.
Click any blank area in the report body. The business view bound to the web report or library component is displayed in the Data panel.
Expand the Dynamic Resources > Formulas node, click <New Formula…>, then create the formula as required.
Find the Invisible property of the desired object in the Report Inspector, click in the value cell and click the drop-down arrow. The formula you just created is listed in the drop-down list. Select it to control the property value. You can also select the <New Formula> item from the drop-down list to create a new one to use.

Then at runtime, whether the object is shown or hidden will be determined by the return value of the formula. A return value of true will hide the component.

Example: Changing the banded panel background color at runtime

This example uses the formula MColor to control the Background property of the detail panel of a banded report at runtime. You can find this formula in Data Source 1 of the catalog SampleReports. The following is the content of the formula:

String sc = "" + (@MColor_RecordNumber *10 );
Number idx = InStr(".",sc);
if(idx != -1)
          sc = Left(sc, idx);
if(Length(sc) < 2)
          sc = "0" + sc;
String s = "0x00" + sc + "7f";
return s

In this example we will vary the middle hexadecimal digits of the RGB color values. The Red value is fixed at 0x00, the Blue value is fixed at 0x7f. The Green value will change according to the number of records displayed. Record 1 will use color 0x00107f, Record 2 will use 0x00207f, and so on.

Take the following steps:

Make sure SampleReports.cat is the currently open catalog file. If not click File > Open Catalog to open it from <install_root>\Demo\Reports\SampleReports.
Create a page report with a standard banded object in it based on a query stored in Data Source 1 of the catalog.
In the design area, select the detail panel (DP) of the banded object.
In the Properties sheet of the Report Inspector, click the value cell of the property Background, and click . From the drop-down list, select MColor.
Click the View tab to view the report. The report will be shown somewhat as follows, depending on the report you use.

Previous Page Next Page