Add HTML into a Report (Report Builder and SSRS)

  • Article

Using a placeholder, you can import HTML from a field in your dataset for use in the report. By default, a placeholder represents plain text, so you will need to change the placeholder mark-up type to HTML. For more information, see Importing HTML into a Report (Report Builder and SSRS).

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.

To add HTML from a field in your dataset into a text box

  1. On the Insert tab, click List. Click the design surface, and then drag to create a box that is the size you want.

    The Dataset Properties dialog box opens. You can use a shared dataset or a dataset embedded in your report. For more information, click Dataset Properties Dialog Box, Query (Report Builder) or Dataset Properties Dialog Box, Query.

  2. On the Insert tab, click Text Box. Click in the list, and then drag to create a box that is the size you want.

  3. Drag an HTML field from your dataset into the text box. A placeholder is created for your field.

  4. Right-click the placeholder, and then click Placeholder Properties.

  5. On the General tab, verify that the Value box contains an expression that evaluates to the field you dropped in step 3.

  6. Click HTML - Interpret HTML tags as styles. This causes the field to be evaluated as HTML.

  7. Click OK.  

See Also

Reference

Placeholder Properties Dialog Box, General (Report Builder and SSRS)

Concepts

Formatting Numbers and Dates (Report Builder and SSRS)

Formatting Lines, Colors, and Images (Report Builder and SSRS)