Linear Scale Properties Dialog Box, Number
SQL Server 2008 R2
Select Number on the Linear Scale Properties dialog box to specify how numeric and date values appear on a linear gauge. Options change depending on which value type is being formatted.
Select how you want the numbers to appear, for example, as money or a percentage. For example, if you want to format the number as a currency value, select Currency.
This area displays an example of how the number appears in the selected category.
Select to display numbers based on the regional settings of the person running the report. If the regional settings are set in the RDL, this check box is not available.
Specify how many decimal places you want to display.
Select to insert a separator between the thousands and the hundreds place. By default, this check box is selected.
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.78.
Select to replace zero values with a blank space or a dash (-) when the report is run.
Enter the monetary symbol that you want to display with your numeric data. By default, the symbol based on your locale is displayed.
Select to position the monetary symbol after the numeric data. By default, this box is not selected.
Select to add a space between the symbol and the monetary value.
Select the format that you want to use when displaying negative numbers.
Select the type of formatting you want to apply to the date or time.
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 (MSDN).