` in the text box.
5. In the Properties pane, for the **Value** property, you see the following (if you don't see the Properties pane, on the **View** tab, check **Properties**):
```
=First(Fields!FullName.Value, "TextDataSet")
```
The `First` function is designed to retrieve only the first value in a field, and that is what it has done.
Dragging the field directly to the design surface created a text box. Text boxes by themselves are not data regions, so they do not display data from a report dataset. Text boxes in data regions, such as tables, matrices, and lists, do display data.
6. Select the text box (if you have the expression selected, press ESC to select the text box), and press the DELETE key.
### To add a field to the report (and get the right result)
1. On the **Insert** tab of the ribbon, in the **Data Regions** area, click **List**. Click the design surface, and then drag to create a box that about two inches wide and one inch tall.
2. Drag the **FullName** field from the Report Data pane to the list box.
This time Report Builder creates a text box with the expression `[FullName]` in it.
3. Click **Run**.
Note that this time the box repeats to show all the records in the query.
4. Click **Design** to return to design view.
5. Select the expression in the text box.
6. In the Properties pane, for the **Value** property, you see the following:
```
=Fields!FullName.Value
```
By dragging the text box to the list data region, you display the data that is in that field in the dataset.
7. Select the list box and press the DELETE key.
## Add a Table to the Report Design Surface
Create this table so you'll have a place to put hyperlinks and rotated text.
1. On the **Insert** tab > **Table** > **Table Wizard**.
2. On the **Choose a dataset** page of the New Table or Matrix wizard, click **Choose an existing dataset in this report or a shared dataset** > **TextDataset (in this Report)** > **Next**.
3. On the **Arrange fields** page, drag the **Territory**, **LinkText**, and **Product** fields to **Row groups**, drag the **Sales** field to **Values**, then click **Next**.
4. On the **Choose the layout** page, clear the **Expand/collapse groups** check box so you can see the whole table, then click **Next**.
5. Click **Finish**.
6. Click **Run**.
The table looks OK, but it has two Total rows. The **LinkText** column doesn't need a Total row.
8. Click **Design** to return to design view.
9. Select the the **Total** cell in the **LinkText** column, then hold down the SHIFT key and select the two cells to its right: and the empty cell in the **Product** column and the `[Sum(Sales)]` cell in the **Sales** column.
11. With those three cells selected, right-click one of those cells and click **Delete Rows**.
12. Click **Run**.
Now it has only one Total row.
## Add a Hyperlink to the Report
In this section, you add a hyperlink to text in the table from the previous section.
1. Click **Design** to return to design view.
2. Right-click in the cell containing `[LinkText]`, and click **Text Box Properties**.
3. On the **Action** tab, click **Go to URL**.
5. In the **Select URL** box, click **[URL]**, then click **OK**.
6. Note that the text does not look any different. You need to make it look like link text.
7. Select `[LinkText]`.
8. On the **Home** tab > **Font**, select **Underline**, and change **Color** to **Blue**.
9. Click **Run**.
The text now looks like a link.
10. Click a link. If the computer is connected to the Internet, a browser will open to a Report Builder Help topic.
## Rotate Text in the Report
In this section, you rotate some of the text in the table from the previous sections.
1. Click **Design** to return to design view.
2. Click in the cell containing `[Territory].`
3. On the **Home** tab in the **Font** section, click the **Bold** button.
4. If the Properties pane is not open, on the **View** tab, select the **Properties** check box.
5. Locate the WritingMode property in the Properties pane, and change it from **Default** to **Rotate270**.
> [!NOTE]
> When the properties in the Properties pane are organized into categories, WritingMode is in the **Localization** category. Be sure you have selected the cell and not the text. WritingMode is a property of the text box, not of the text.
6. On the **Home** tab > **Paragraph** section, select **Middle** and **Center** to locate the text in the center of the cell both vertically and horizontally.
8. Click Run (**!**).
Now the text in the `[Territory]` cell runs vertically from the bottom to the top of the cells.
## Format Currency
1. Click **Design** to switch to design view.
2. Click the top table cell that contains `[Sum(Sales)]`, hold down the SHIFT key, and click the bottom table cell that contains `[Sum(Sales)]`.
3. On the **Home** tab > **Number** group > **Currency** button.
4. (Optional) If your regional setting is English (United States), the default sample text is [**$12,345.00**]. If you do not see an example currency value, in the **Numbers** group, click **Placeholder Styles** > **Sample Values**.
5. (Optional) On the **Home** tab, in the **Number** group, click the **Decrease Decimals** button twice to display dollar figures with no cents.
6. Click Run (**!**) to preview the report.
The report now displays formatted data and is easier to read.
## Displaying Text with HTML Formatting
1. Click **Design** to switch to design view.
2. On the **Insert** tab, click **Text Box**, and then on the design surface, click and drag to create a text box under the table, about four inches wide and three inches tall.
3. Copy this text and paste it into the text box:
```
Limitations of cascading style sheet attributes
Only a basic set of cascading style sheet (CSS) attributes are defined:
-
text-align, text-indent
-
font-family, font-size
-
color
-
padding, padding-bottom, padding-top, padding-right, padding-left
-
font-weight
```
4. Drag the lower edge of the text box so all the text fits. You notice the design surface gets larger as you drag.
5. Select all of the text in the text box.
5. Right-click all of the selected text and click **Text Properties**.
This is a property of the text, not the text box, so in one text box you could have a mixture of plain text and text that uses HTML tags as styles.
6. On the **General** tab, under **Markup type**, click **HTML - Interpret HTML tags as styles**.
7. Click **OK**.
8. Click Run (**!**) to preview the report.
The text in the text box is displayed as a heading, paragraph, and bulleted list.
## Save the Report
You can save reports to a report server, SharePoint library, or your computer.
In this tutorial, save the report to a report server. If you do not have access to a report server, save the report to your computer.
### To save the report on a report server
1. From the **Report Builder** button, click **Save As**.
2. Click **Recent Sites and Servers**.
3. Select or type the name of the report server where you have permission to save reports.
The message "Connecting to report server" appears. When the connection is complete, you see the contents of the report folder that the report server administrator specified as the default location for reports.
4. In **Name**, replace the default name with a name of your choosing.
5. Click **Save**.
The report is saved to the report server. The name of report server that you are connected to appears in the status bar at the bottom of the window.
### To save the report on your computer
1. From the **Report Builder** button, click **Save As**.
2. Click **Desktop**, **My Documents**, or **My computer**, and then browse to the folder where you want to save the report.
3. In **Name**, replace the default name with a name of your choosing.
4. Click **Save**.
## Next Steps
There are many ways to format text in Report Builder. [Tutorial: Creating a Free Form Report](../reporting-services/tutorial-creating-a-free-form-report-report-builder.md) contains more examples.
[Report Builder Tutorials ](../reporting-services/report-builder-tutorials.md)
[Formatting Report Items](../reporting-services/report-design/formatting-report-items-report-builder-and-ssrs.md)
[Report Builder in SQL Server 2016](../reporting-services/report-builder/report-builder-in-sql-server-2016.md)
More questions? [Try asking the Reporting Services forum](http://go.microsoft.com/fwlink/?LinkId=620231)