Post reply

parse html tags in RS

  • July 29, 2004 at 3:13 pm

    #108669

    I have a column in a table that has a huge string with html tags. I created a report that has some data coming from different tables. now i need to print out the html formatted string in the report but parsed. how would i do it ?

    for xample: lets say my data in the column reads:

    <font face="verdana" size="2">This is <b>test page</b>

    when i write this out to the report it should parse the html tags and print it as

    This is test page

    in the report.

    I'd appreciate any help in this.

    thanks,

    dinakar

  • August 2, 2004 at 1:48 am

    #517187

    Hi,

    I have a report, which acts in the same way. What I do is place the HTML in a table. I then BCP the contents of the table to a .htm file which gets mail to all the people who need to get the report.

  • August 2, 2004 at 9:03 am

    #517280

    Hi GC

    Thanks for the reply. BCP would work fine if we r just printig out results of a query/stored proc directly to an html file. but my report is formatted. it has some images ( logos) etc and its generated from 6-7 queries not just one. i have an address coming from one table, another address from another table. and few records from one more table..and so on.

    you have any ideas on how i can go about my prob. ?

    thanks.

    Dinakar

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply