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

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 2

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

Answer 3

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 4

I have done this by writing a custom control as another user mentioned. Such a PITA!

Answer 5

I've gotten some expressions in the placeholders to render as HTML, example, =" [left_carrot H1 right_carrot] MyHeading [left_carrot forward_slash H1 right_carrot]" (replace left_carrot with < and right_carrot with >). You have to set the markup type as HTML in the placeholder properties.

My question is, where is the style sheet that controls the font and size of H1 when it renders to the ReportManager web site.

Thanks.