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.
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”
- Click Ok > the HTML tags should be now formatted in SSRS report properly as shown below:
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.