SQL Server Performance Forum – Threads Archive

How to Display HTML Column

Hi All, I have a column storing text including html tags. Therefore when the report runs it shows the html tags. How do I tell RS that there are html tags and the text must be display properply per html tags or at least the tags are removed? Thanks. Sample text: Edited by xxxxx on Monday, August 07, 2006 at 8:50 AM faxed letter to agent; given agent up to 08/11/2006 to respond. faxed to agent, SCIF renewal quote effective 09/01/2006 Edited by xxxx on Wednesday, August 30, 2006 at 9:58 AM Agent never responded back prior to 8/11/2006 to provide rescinding B O R letter. Expected: Edited by xxxxx on Monday, August 07, 2006 at 8:50 AM
faxed letter to agent; given agent up to 08/11/2006 to respond.
faxed to agent, SCIF renewal quote effective 09/01/2006
Edited by xxxx on Wednesday, August 30, 2006 at 9:58 AM
Agent never responded back prior to 8/11/2006 to provide ; rescinding B O R ; letter. Or at least: Edited by xxxxx on Monday, August 07, 2006 at 8:50 AM
faxed letter to agent; given agent up to 08/11/2006 to respond.
faxed to agent, SCIF renewal quote effective 09/01/2006
Edited by xxxx on Wednesday, August 30, 2006 at 9:58 AM
Agent never responded back prior to 8/11/2006 to provide ; rescinding B O R ; letter.

Check for HTML renderer in books online,http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/ &http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/ links fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

]]>