Export (0) Print
Expand All

Formatting Numbers and Dates (Report Builder and SSRS)

You can format numbers and dates in data regions by selecting a format from the Number page of the corresponding data region's Properties dialog box.

To specify format strings within a text box report item, you need to select the item that you want to format, right-click, select Text Box Properties, and then click Number. You can format individual cells in a table or matrix data region in the same manner, because cells in a table or matrix are individual text boxes.

A chart data region commonly shows dates along the category (x) axis, and values along the value (y) axis. To specify formatting in a chart, right-click an axis and select Axis Properties. On the value axis, you can specify formats only for numbers. For more information, see Formatting Axis Labels on a Chart (Report Builder and SSRS).

To specify formatting in a Gauge data region, right-click the scale of the gauge and select Radial Scale Properties or Linear Scale Properties.

Note Note

If some formatting options you want to use are grayed out, it means that those formatting options are not compatible the field's data type, which is set in the data source. For example, if the field contains number values but the field's data type is String, you cannot apply numerical data formatting options such as currency or decimals.

Note Note

You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

Before you format numbers and dates in your report, consider the following:

  • By default, numbers are formatted to reflect the cultural settings on the client computer. Use formatting strings to specify how numbers are displayed so that formatting is consistent regardless of where the person who is viewing the report is located.

  • The formats provided on the Number page are a subset of the .NET Framework standard numeric format strings. To format a number or date using a custom format that is not shown in the dialog box, you can use any .NET Framework format strings for numbers or dates. For more information about custom format strings, see the Formatting Types topic on MSDN.

  • If a custom format string has been specified, it has a higher priority over default settings that are culture-specific. For example, suppose you set a custom format string of "#,###" to show the number 1234 as 1,234. This may have different meaning to users in the United States than it does to users in Europe. Before you specify a custom format, consider how the format you choose will affect users of different cultures who may view the report.

  • If you specify an invalid format string, the formatted text is interpreted as a literal string which overrides the formatting.

  • If you are formatting a mix of numbers and characters in the same text box, consider using a placeholder to format the number separately from the rest of the text. For more information, see Formatting Text and Placeholders (Report Builder and SSRS). If an invalid format string is specified for the Format property on the text box, the format string is ignored. If an invalid format string is specified for the Format property on the chart or gauge, the format string that you specified is interpreted as a string and formatting is not applied.

  • If you select Currency under Category and you check Show values in, you can 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.

Community Additions

ADD
Show:
© 2014 Microsoft