SQL Server Performance

How to Display HTML Column

Discussion in 'SQL Server Reporting Services' started by hthan, Sep 20, 2006.

  1. hthan New Member

    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.


  2. satya Moderator

    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.

Share This Page