Converting a particular currency type with a computed column

You can convert a particular currency field to the type entered by your user by creating a Computed Column in a data set.

The Open Data Access (ODA) framework in BIRT converts the Currency Field in BMC Remedy AR System to the following fields:

•  <Field Name>.OBJECT
•  <Field Name>.VALUE
•  <Field Name>.TYPE

OBJECT is of type String and has currency value as well as currency type.

To convert a currency field to the user entered currency type

1. With a report open in the Layout tab of the layout editor, click the Data Explorer tab, and double-click a data set under the Data Sets node.
2. In the Edit Data Set dialog box, click Computed Columns.
3. Click New.
4. In the Column Name field, type a name for the computed column.
5. In the Data Type field, select Decimal.

6. In the Expression field, type the expression, for example:

   if (row["Associated Cost.OBJECT"].toFunctionalValue(params["CurrencyType"].value)
7. Click OK, then click Preview Results.

Related topic

Examples-of-modifying-reports-with-the-BIRT-Report-Designer