How to Display HTML Column | SQL Server Performance Forums

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: <B>Edited by xxxxx on Monday, August 07, 2006 at 8:50 AM</B><BR>faxed letter to agent; given agent up to 08/11/2006 to respond.<BR>faxed to agent, SCIF renewal quote effective 09/01/2006<BR><BR><B>Edited by xxxx on Wednesday, August 30, 2006 at 9:58 AM</B><BR>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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |