Display and Interpret HTML tags as Styles in SSRS

In this article, I will explain

How to display HTML fields in SSRS


Scenario

I tried to add a multi-line enhanced text field to SSRS Report, I noticed that it is not interpreted and it displayed as HTML tags as shown below.

display HTML fields in SSRS


Cause

In SharePoint & Project Server, The Multi-line text custom field saves its data with HTML tags that require being interpreted as Styles in SSRS report.


Solution

Interpret HTML tags as styles in SSRS Report

Steps
  • Double click on the TextBox that holds the Multiline custom field value and
  • Below Markup types > Selects “HTML – Interpret HTML tags as styles”

HTML - Interpret HTML tags as styles

  • Click Ok > the HTML tags should be now formatted in SSRS report properly as shown below:

Interpret HTML tags as Styles in SSRS


The supported HTML Tags in SSRS

The below are the supported HTML Tags that will render as HTML in SSRS.

  • Hyperlinks: < a href>
  • Fonts: < font >
  • Header: <H{n}>.
  • Text format: < p >,< div >,< span >
  • List handling: < lo >,< li >

Applies To
  • SQL Server Reporting Service.
  • SharePoint.
Conclusion

In this article, I have explained How to show the Html text in SSRS.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s