{{sidenavigation.sidenavigationExpandLabel}}
{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}} {{helpModel.downloadHelpPdfDataStatus}}

Tab Number

This tab is only visible for report elements based on a number. By default the language dependent format is used.

Number Type

  • Integer: the whole number only (property formula constant "integernumberformat")
  • Currency: the number including the currency symbol (property formula constant "currencynumberformat")
  • Fractional: the number including its decimal digits (property formula constant "fractionalnumberformat")
  • Percent: the number multiplied by 100, with a percent sign (property formula constant "percentnumberformat")
  • Use Custom Format: Use your own customized number format (property formula constant "usecustomformat")

Suppress if Zero

If checked this element will be suppressed if its value or rounded value is zero.

Decimals

Choose the number of decimals to be shown.

If you are using the formula to select the number of decimal digits, you have to return the number from the formula. Returning 0 implies no decimal places.

Example: if you'd like to define two decimal digits the formula has to return 2, which corresponds to selecting 1.00 from the list.

Rounding

Choose where to round the number. The Decimals and Rounding values depend on each other and may change automatically.

Be aware that there is an exception in setting these value per formula. If you are using the formula for rounding the value it sets the index, at which decimal place the rounding should be done.

Example: if you'd like to round to four decimal places, return a 4. If you'd like to round to full thousands, return a -3 which is equal to selecting the 1,000 list item.

Rounding Mode

Choose the Rounding modes for the number.

Negatives

Choose the style for negatives.

Reverse Sign

Reverse the sign of the given value.

Allow Field Clipping

Usually a field is clipped when the value does not fit into its designed space. As this might give wrong values (8 clipped to 3) you may want to disable this, but its better to correct the size of the field in design.

Decimal Separator

The separator used between the integer and fractional part.

Use Thousands Separator

Show a thousands separator or not.

Thousands Separator

Choose the thousands separator.

Use Leading Zero

Check this to show a leading zero if the integer part of the number is zero.

Show Zero Values as

Choose what to display if the value or rounded value is zero.

Currency Type

You can choose between showing no symbol or showing a floating symbol (attached to the value) or fixed symbol.

Currency Position

Choose where to show the currency symbol relative to number and sign. There are always four items with principle meaning as follows:

  • leading currency, negative inside
  • leading currency, negative outside
  • trailing currency, negative inside
  • trailing currency, negative outside

Be aware that the items of this box may change corresponding to your settings for currency symbol and negatives type. So it is possible that there are equal items in this list box.

Currency Separator

The separator between currency symbol and value.

Currency Symbol

The currency symbol to use.

One Currency Symbol per Page

Specifies if the currency symbol will be displayed for all records of a field or only for the first record on a page.

Property Formulas

Note that all properties can also be set by property formula. See the formula constants for help on which return values these property formulas should have.

i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - Number Properties