Format Dialog Box (Number Tab) (Report Builder)
Use the Number tab of the Format dialog box to specify how numerical and date values appear within a selected cell or data region. Options change depending on which value type is being formatted.
Note
If you find that formatting options you want to use are grayed out, it means that the field's data type, which is located in the data source, and the formatting options are not compatible. For example, if the field contains numeric values but the field's data type is "string", numerical data formatting options, such as currency or decimals, cannot be applied and the numerical formatting options are grayed out.
Options
- Defined formats
Select to format numerical data using the options available in Report Builder.
- Format
Select how you want the numbers to appear, for example, as money or a percentage.
- Decimal places
Specify how many decimal places you want to display.
- Symbol
Enter the monetary symbol that you want to display with your numerical data. By default, the symbol based on your locale is displayed.
- Postfix
Select to position the monetary symbol after the numerical data. By default, this box is not selected.
- Use 1000 Separator
Select to insert a separator between the thousands and the hundreds place. By default, this check box is selected.
- Negative numbers
Select the format that you want to use when displaying negative numbers.
- Custom format
Enter a valid .NET Framework format string to customize the appearance of your numerical data. For more information about valid .NET Framework format strings, see the Microsoft Developer Network (MSDN).
See Also
Other Resources
Formatting a Report (Report Builder)
Formatting Numerical Data (Report Builder)
How to: Format a Number Field (Report Builder)