Home
Welcome to the SqlServerReportingServicesExamples wiki!
How To Format a SSRS textbox as HTML.
References:
http://msdn.microsoft.com/en-us/library/cc627491.aspx http://msdn.microsoft.com/en-us/library/cc645967.aspx
Highlight the text in the textbox and right-click and select "Placeholder Properties…"
Then select the option "HTML – Interpret HTML tags as styles"
Example:
="Please forward any change request for this report to: " & Parameters!ReportOwner.Value &" "
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,
"" & Fields!SearchForStr.Value &
"")
)
The following is a complete list of tags that will render as HTML when defined as placeholder text:
Fonts:
Header, style and block elements: <H{n}>,
,
Text format: , , ,
List handling:
- ,
- ,
