Data Formatting Properties
The following is a list of properties available in the data formatting dialog.
- "Not Applicable" Characters
Specifies the characters to be displayed when the value to be formatted was not applicable. The default value is two dashes (--). Note that the format will be applied only if the data source supports this error condition. - Any Error Characters
Specifies the characters to be displayed when the value to be formatted was not available because of an error. This property is overridden by the more specific formatting error conditions, such as Security Error Characters. The default value is two dashes (--). Note that the format will be applied only if the data source supports this error condition. - Calendar Type
Specifies the type of calendar to be displayed. The date values will be mapped to the selected calendar before being formatted. The default value is inherited from the user's content language. Note that the Japanese Imperial setting is only applicable for Japanese languages. - Clock
Specifies whether to display the time in 12-hour or 24-hour format. The default value is inherited from the user's content language. - Currency
Specifies the currency to be used. The default currency symbol will be displayed unless the values of the Currency Display and Currency Symbol properties are changed. The default value is inherited from the model. - Currency Display
Specifies whether to display the international or local currency symbol. By default, the local currency symbol is displayed. - Currency Symbol
Specifies a character or characters to use as the symbol to identify the local currency. This symbol will precede the number and any sign, even if it is a leading sign. A space between the symbol and the numeric value can be specified by entering it in this property, after the symbol. The default value is inherited from the user's content language. - Currency Symbol Position
Specifies where the currency symbol will appear. If End is selected, any spaces that follow the character or characters in the Currency Symbol or International Currency Symbol properties will be rendered between the number and the symbol. The default value is inherited from the user's content language. - Date Ordering
Specifies the order in which to display the day, month, and year. The default value is inherited from the user's content language. - Date Separator
Specifies the character to be displayed between the year, month, and day. The default value is inherited from the user's content language. - Date Style
Specifies the date style. The results rendered are determined by the language. Generally, Short uses only numbers, Medium uses some abbreviated words, Long uses complete words, and Full includes all available details. - Decimal Separator
Specifies the character that will separate non-decimal numbers from decimals. This property is ignored if no decimals are displayed. The default value is inherited from the user's content language. - Digit Shaping
Specifies the digit shaping option to apply. When National is selected, digit shapes are determined from the user’s content language. When Contextual is selected, digit shapes are determined from adjoining characters in the value. For example, if the most recent strongly directional character before the numerical character is left-to-right, the number is displayed as a European number. If the most recent strongly directional character before the numerical character is right-to-left, the number is displayed in Arabic-Indic format. If there are no strongly directional characters before the numerical character, the number is displayed according to the base text direction of the field. When None is selected, no shaping is performed, and the value as it appears in the data source is shown. The default depends on the type of value. When the value is a string, the default is None. - Digit Shaping
Specifies the digit shaping option to apply. When National is selected, digit shapes are determined from the user’s content language. When None is selected, no shaping is performed, and the value as it appears in the data source is shown. The default depends on the type of value. When the value is a number, the default is the ICU default for the language. - Display AM / PM Symbols
Specifies whether to display the AM or PM symbols. The default value is inherited from the user's content language. - Display As Exponent
Specifies whether to render values in scientific notation, using exponents. If this property is set to No, scientific notation will not be used. If this property is not specified, scientific notation will be used only when values exceed the maximum number of digits. The default value is inherited from the user's content language. - Display Days
Specifies whether to display the day. The format of the day can be controlled by selecting one of the specific formats. Selecting Julian means that the 3-digit day of the year will be displayed. The default value is inherited from the user's content language. - Display Eras
Specifies whether to display the era. The default value is inherited from the user's content language. - Display Hours
Specifies whether to display the hours. The default value is inherited from the user's content language. - Display Milliseconds
Specifies whether to display the milliseconds. The format of the milliseconds can be controlled by selecting one of the specific formats. This property is ignored if seconds are not displayed. The default value is inherited from the user's content language. - Display Minutes
Specifies whether to display the minutes. The format of the minutes can be controlled by selecting one of the specific formats. The default value is inherited from the user's content language. - Display Months
Specifies whether to display the month. The format of the month can be controlled by selecting one of the specific formats. The default value is inherited from the user's content language. - Display Months
Specifies whether to display the month. Use this property only when the report is processed entirely in the database, and no local processing is required. The associated database columns must have a YEAR-MONTH interval, and not a DAY-TIME type of interval. - Display Seconds
Specifies whether to display the seconds. The format of the seconds can be controlled by selecting one of the specific formats. The default value is inherited from the user's content language. - Display Time Zone
Specifies whether to display the time zone. The default value is inherited from the user's content language. - Display Weekdays
Specifies whether to display the weekday. The format of the weekday can be controlled by selecting one of the specific formats. The default value is inherited from the user's content language. - Display Years
Specifies whether to display the year. The first two digits of the year, which indicate the century, can be controlled by selecting one of the associated property values. The default value is inherited from the user's content language. - Display Years
Specifies whether to display the year. Use this property only when the report is processed entirely in the database, and no local processing is required. The associated database columns must have a YEAR-MONTH interval, and not a DAY-TIME type of interval. - Divide By Zero Characters
Specifies the characters to be displayed when a numeric value is the result of a division by zero. The default value is /0. Note that the format will be applied only if the data source supports this error condition. - Exponent Symbol
Specifies the character to be displayed to identify exponents if the scientific notation is used. The symbol will be rendered after the number, separated by a space. The default value is inherited from the user's content language. - Group Size (digits)
Specifies the primary grouping size. If a value is specified it represents the number of digits to the left of the decimal point to be grouped together and separated by the thousands separator. The default value is inherited from the user's content language. - International Currency Symbol
Specifies a character or characters to use as a symbol to identify the international currency. This symbol will replace the currency symbol. A space between the symbol and the numeric value can be specified by entering it in this property, after the symbol. The default value is inherited from the user's content language. - Mantissa (digits)
Specifies the number of digits to be displayed following the exponent symbol if the scientific notation is used. - Maximum No. of Digits
Specifies the maximum number of digits that can be displayed. If the maximum number of digits is not sufficient to display the value, a scientific notation will be used. The default value is inherited from the user's content language. - Minimum No. of Digits
Specifies the minimum number of digits that can be displayed. If the minimum number of digits is too high to display a value, the padding character will be used. The default value is inherited from the user's content language. - Missing Value Characters
Specifies the character or characters to be displayed when the value is missing. If no value is entered for this property, an empty string will be displayed. - Negative Pattern
Specifies a presentation format, based on patterns, for negative numbers. Some restrictions exist. The numerical part of the negative pattern is ignored. Only the suffix and the prefix are used. For example, in the pattern ABC#,##0.#EFG, ABC is the prefix, EFG is the suffix and #,##0.# is the numerical part of the pattern. - Negative Sign Position
Specifies where the negative sign will appear. The default value is inherited from the user's content language. - Negative Sign Symbol
Specifies how to display negative numbers. The default value is inherited from the user's content language. - No. of Decimal Places
Specifies the number of digits to be displayed to the right of the decimal point. If this property is not set, the number of decimal places will vary depending on the number rendered. - Numeric Overflow Characters
Specifies the characters to be displayed when a numeric value is the result of a numeric overflow. The default value is two dashes (--). Note that the format will be applied only if the data source supports this error condition. - Padding Character
Specifies the character that will be used to pad values that have fewer digits than the minimum number of digits. The default value is inherited from the user's content language. - Pattern
Specifies a presentation format that is based on patterns. The pattern format overrides formats specified in other properties. For example, to format the date as 2009/12/31 23:59:59 PM, use the pattern yyyy/MM/dd hh:mm:ss aa. For example, to format thousands using the letter K, set the Format Type to Number, set the Scale to -3 (to remove 000), and then use the pattern to ####K. - Percentage Symbol
Specifies whether to display the values per hundred (percent) or per thousand. The symbol will be appended to the number and any trailing sign. A space between the numeric value and the symbol can be specified by entering it in this property, after the symbol. The default value is inherited from the user's content language. - Percent Scale (integer)
Scale to be applied to value after formatting. If omitted, no percent scale will be applied and the value will formatted according the normal decimal positioning associated with the percent (or per mille) symbol. - Scale
Specifies how many digits to move the decimal delimiter for formatting purposes. For example, move the decimal three spaces to present values in thousands. The default value is inherited from the database field. - Secondary Group Size (digits)
Specifies the secondary grouping size. If a value is specified it represents the number of digits to the left of the primary group that will be grouped together and separated by the thousands separator. If this property is left blank, the secondary grouping of digits is the same number as the primary group size, as specified by the Group Size (digits) property. The default value is inherited from the user's content language. - Security Error Characters
Specifies the characters to be displayed when the value to be formatted was not available for security reasons. The default value is #!Security. Note that the format will be applied only if the data source supports this error condition. - Thousands Separator
Specifies how to delimit digit groups, such as thousands. This property is only used if the Use Thousands Separator property is set to Yes. The default value is inherited from the user's content language. - Time Separator
Specifies the character to be displayed between the hour, minute, and second. The default value is inherited from the user's content language. - Time Style
Specifies the time style to be displayed. The exact results that will be rendered are determined by the language. Generally, Short means that the minimum details will be displayed, Long adds seconds, and Full means that all details are displayed, including the time zone. The default value is inherited from the user's content language. - Time Unit
Specifies the unit of measure of the value. This property will be ignored if any day or time components are shown. The default value is inherited from the user's content language. - Use Thousands Separator
Specifies whether the grouping delimiter will be applied as defined by the Group Size property. The default value is inherited from the user's content language. - Zero Value Characters
Specifies the character or characters to be displayed when the value is zero (0). If no value is entered for this property, the Maximum No. of Digits property determines how many zero digits are displayed.
Parent topic: Report Studio Object and Property Reference