I have some HTML stored in a SQL Server table that I want to render in Reporting Services 2008,

HTML data contain HTML table. While generating report, SSRS not able to render it properly as table.

Can anybody help me out how we can display the HTML data as it is in SSRS 2008?

Hi,

Yes, you can do this by creating Placeholder and then by setting Markup Type as HTML. For more detils refer setps given below

http://sqlblog.com/blogs/greg_low/archive/2008/08/25/displaying-html-content-in-reporting-services-2008.aspx

Kindly have a look at below link to which tags are supported

http://msdn.microsoft.com/en-us/library/cc645967.aspx

Reporting Services does not support HTML tables. Only a few tags such as bold, italic, lists etc are supported. Not tables.

 Hi,

As James mentioned, only a limited set of HTML elements are supported in SSRS placeholders. They are

• 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>

For further details, please refer http://msdn.microsoft.com/en-us/library/cc645967.aspx

this is how I make it.

1. Convert the html code into image by html2image dll (please find in codeplex)

2. save contents with converted html image as base64 string into table.

2. show the content as image.