HTML & Reporting Services

  • Please Help!

    I have been browsing the Internet and SSC and still cannot find a way to render HTML from a table.  I have HTML stored in a table.  I would like to put a table on a report and have the textual HTML rendered as a webpage within Reporting Services.  Basically, I want to show the end-user what the Web-Page looked like at a specific time & date. 

    Example:

    "<

    html><head><title></title></head><body>This is a test<br /><br /><br /><br />Greg Grow 1234 N Main St, Done, City, State 55555<br /></body></html>"

    The goal I have is to fetch this row from the database, and display it as if was rendered in a web browser.  Any help would be much appreciated.

  • If you want to render the HTML as it came from the database, IMHO Reporting Services would not be the right way to do it. 

    Reporting Services, by definition, are format-neutral. IOW, the reports should be renderable by different handlers (HTML, PDF, whatever).  So telling RS that you want it to render HTML as a base format doesn't make sense.

    I'm sure it would be possible to add a special little ASP.NET page into your reports web root (or whatever, in the virtual directory) that would do what you want. Would this do for your purposes, do you think? I am assuming that you have (other) reasons to use RS.

    I can also see potential for a real a*s-backward way of forcing this to happen with some XSLT applied to the reporting content -- something that RS *can* do.  This assumes that your html is well-formed, which it appears to be (IOW no unclosed <br> tags or anything). You might also have to un-escape the blob of html text during the transform -- and I have no idea what the export (to Excel or whatever) would look like.

    >L<

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

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