Summary

SSRS supports a comprehensive set of formatting capabilities through the report item's properties, which control output appearance.

Some of the key properties are as follows :

• BackgroundColor Controls background color of the item. When a report requires alternating colors for rows of output, this property can be used in conjunction with functions RowNumber() and RunningValue .

• Color Controls the color of the text.

• Format .NET Framework formatting string to apply to the item. The following are examples of format strings:

  • ###.## formats a value of 012.30 to the following output 12.3

  • (###)###-#### formats a value of 1234567890 to the output [phone] , which is typical presentation of a phone number

  • C formats a value of 1234.56 to typical presentation of currency $1,234.56

  • yyyy-MM-dd HH:mm formats 11:59PM on 1/2/2006 to 2003-01-02 23:59

• Language Controls locale formatting. For example, when set to " English (United Kingdom) " currency sign in formatting changes from $ to e

• PageBreakAtEnd and PageBreakAtStart Control pagination before and after an item.

• PageHeight and PageWidth Control physical page sizing for PDF- and image-rendering extensions.

The following chapter discusses functionality that SSRS provides to simplify navigation in large reports and within the hierarchy of reports .