Can I render HTML from SQL Database in SSRS 2005?

Question

I have html in an MS SQL DB. I would like to render the html on a SSRS page, is this possible?

Answer 1

This kind of capability was deliberately disabled in SQL 2005 Reporting Services because of 'security reasons'. I believe the advice at the time was to record any html as an image and embed the image in the report. I decided to abandon reporting services all together instead. Sorry!

If you are using SQL 2008 you can use some HTML in your reports. However, there are some limitations to the markups that can be used:

The following is a complete list of tags that will render as HTML when defined as placeholder text:

* Hyperlinks: <A href>
* Fonts: <FONT>
* Header, style and block elements: <H{n}>, <DIV>, <SPAN>,<P>,
          <DIV>, <LI>, <HN>
* Text format: <B>, <I>, <U>, <S>
* List handling: <OL>, <UL>, <LI>

Any other HTML markup tags will be ignored during report processing

Answer 2

I do not believe so. The output that is created from an SSRS report is not an HTML document and I've never been able to get html output to render correctly in the report.

Answer 3

I don't know of any easy way of doing it, you may have to write your own custom control to do this.