Export (0) Print
Expand All
Expand Minimize

Choose Format (Report Designer)

SQL Server 2005

Updated: 14 April 2006

Use the Choose Format dialog box to specify a text box format. This dialog box opens when you click the ellipsis button (...) in the Format tab of the Textbox Properties dialog box. This is the recommended way of setting the format properties for the contents of a text box containing data of a single data type.

However, if you need more control over the contents because you are combining data types, right-click the text box and select Expression (Fx). You can then use the String.Format function to control the text box contents.

Standard

Select the data format to use for values that appear in the text box. Valid values include Default, Number, Date, Time, Percentage, and Currency. Select a format and an example, and then click OK. For example, N0 specifies no decimal places.

For more information about the types of formatting codes available and how to create custom formatting strings, see "Standard Numeric Format Strings" in the .NET Framework SDK documentation at msdn.microsoft.com.

Custom

Select Custom to specify a custom format code. You can modify the values of the standard format codes and see the results in the Sample box or click the function button (fx) to use the Edit Selected Dataset dialog box to build a custom formatting string. For example, to modify an existing format code to specify the number of decimal places, select Custom and type a custom a formatting string.

Sample

Displays an example of how the value looks when formatted in the code you specify.

Release History

14 April 2006

New content:
  • Added example of modifying standard format code and link to online documentation for format types.

Community Additions

ADD
Show:
© 2015 Microsoft