Skip to content

How to format a SSRS textbox as HTML.

Anthony edited this page Sep 1, 2017 · 3 revisions

References:

Highlight the text in the textbox and right-click and select "Placeholder Properties…"

Then select the option "HTML – Interpret HTML tags as styles"

="Please forward any change request for this report to: <u> <font color='blue'> " & Parameters!ReportOwner.Value &"</u> </font> " 

This code will replace the SearchFor field in the textbox. Nulls are not valid in Replace function.

=IIF(Fields!SearchForStr.Value = " " 

, Fields!Name.Value 

, (Fields!Name.Value).ToString.Replace(Fields!SearchForStr.Value, 

"<I><B><U><S>" & Fields!SearchForStr.Value & 

"</S></U></B></I>") 

) 

The following is a complete list of tags that will render as HTML when defined as placeholder text:

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>