Display and Interpret HTML tags as Styles in SSRS

I have a multi-line text custom field in Project Server, when I tried to use it in SSRS Report, I noticed that it is displayed as HTML tags as shown below.

nothtml

Cause:

Multi line text custom field save its data with HTML tags that require to interpret as Styles in SSRS report.

Solution:

To Interpret HTML tags as styles in SSRS report follow the bit steps below:

  • Double click on Text Box that contain the Multi line custom field and Select HTML – Interpret HTML tags as styles.

selectHtml

  • This causes the field to be evaluated as HTML format as shown below:

afterapplyhtml

The following are the supported HTML Tags  that will render as HTML when defined as placeholder text in SSRS :

  • Hyperlinks: <A HREF>
  • Fonts: <FONT>
  • Header, style and block elements: <H{n}>, <DIV>, <SPAN>,<P>, <DIV>, <LI>, <HN>
  • Text format: <B>, <I>, <U>, <S>
  • List handling: <OL>, <UL>, <LI>

Enjoy 🙂

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s