Add HTML into a Report (Report Builder and SSRS)

 

Applies To: SQL Server 2016

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).

System_CAPS_ICON_note.jpg Note


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.

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.

Formatting Numbers and Dates (Report Builder and SSRS)
Formatting Lines, Colors, and Images (Report Builder and SSRS)
Placeholder Properties Dialog Box, General (Report Builder and SSRS)

Community Additions

ADD
Show: