Export (0) Print
Expand All
Expand Minimize

Placeholder Properties Dialog Box, Number (Report Builder 3.0)

Select Number on the Placeholder Properties dialog box to specify how numeric and date values are formatted when they are displayed as placeholder text. Options change depending on which data type is being formatted.

Category

Select how you want the number or date to appear, for example, as currency or a formatted date.

Use regional formatting

Select to display numbers based on the regional settings of the client machine. If the regional settings are set in the RDL, this check box is not available.

Decimal places

Specify how many decimal places you want to display.

Use 1000 separator

Select to insert a thousands separator.

Show values in

Select Thousands, Millions, or Billions to display numbers using financial formats. For example, if the field value is 1,789,905,394 and you select Billions and specify 2 decimal places, the value displayed in the report is 1.79.

Show zero as

Select to replace leading zero values with a blank space or a dash (-) when the report is run.

Symbol

Enter the monetary symbol that you want to display. By default, the symbol is based on the locale settings.

Show symbol after value

Select to position the monetary symbol after the numeric data.

Include a space

Select to add a space between the monetary symbol and the value.

Negative numbers

Select the format that you want to use when displaying negative numbers.

Type

Select the type of formatting you want to apply to the date or time. Only applicable when Date or Time is selected.

Custom format

Enter a valid .NET Framework format string to customize the appearance of your numeric data. For more information about valid .NET Framework format strings, see the Microsoft Developer Network on MSDN.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft