Formatting Report Items (Report Builder and SSRS)
Applies To: SQL Server 2016
Formatting the items in your report makes the report look more attractive and enhances its readability. You can format the text boxes and individual items within text boxes, the images, the expressions, and the data while in report design mode.
A. Text box with a double-line border and a variety of formatting styles, including a link.
B. Text box with a dashed border and raw HTML and rendered HTML.
C. Text box in with a text label and a placeholder.
You can change formatting options by selecting the item that you want to format and then opening the item's Properties dialog box. For example, if you want to format the contents of an entire text box or a selected word within the text box, right-click the item and select Text Box Properties. Then, you can apply the formatting styles that you want.
To quickly get started, see Tutorial: Format Text (Report Builder).
You can create and modify paginated report definition (.rdl) files 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.
- Formatting Text and Placeholders (Report Builder and SSRS)
Describes how to format text and customize format options for different blocks of text within a text box.
- Importing HTML into a Report (Report Builder and SSRS)
Describes how to insert and use HTML in a report.
- Formatting Numbers and Dates (Report Builder and SSRS)
Describes how to use standard and custom formatting strings that are supported by Reporting Services.
- Formatting Lines, Colors, and Images (Report Builder and SSRS)
Describes how to format lines, gridlines, colors, and images within report items and data regions.
- Set the Locale for a Report or Text Box (Reporting Services)
Describes how to change the setting for data display formats that differ by language and region, such as date, currency, and number values.