Specify the data format for an object

Specify the format for a particular object if you are not getting the results you want.

For example, you add a measure to a report and you want to see two decimals when you run the report. You set the number of decimals to two for the Number format type for the current layout. However, when you run the report, you see more than two decimals for the measure. To get the results you want, you must map the measure to the Number format type.

About this task

Data formats are not applied in delimited text (CSV) and XML report outputs.

The time interval data format assumes that input values are in milliseconds. As a result, when the time interval format is applied to an object, the values that appear in the report output are in milliseconds. You can apply the cast function to return the interval type that you want.

Procedure

  1. Click the object.
  2. In the report object toolbar, click the Data format icon Data format icon.
    Tip: You can also click the Show properties icon Show properties icon, and then double-click the Data format property.
  3. Under Format type, click the format type to apply to the object.
  4. To override any of the properties of the format type that were defined for the current layout, in the Properties box, click the property and specify its value.