The Bit Bucket (Greg Low) : Displaying HTML content in Reporting Services 2008

THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help

Home

Opml

The Bit Bucket (Greg Low)

Ramblings of Greg Low

Displaying HTML content in Reporting Services 2008

A friend of mine that works for Microsoft pinged me yesterday about how to strip HTML tags out of text he was trying to display in Reporting Services. He just wanted the text displayed. The typical text looked like this:

<div class=ExternalClassB9A517D3DE254676B8266F6B2D84FD05>
<p>SciTech Software is a software development and consulting company. The company was founded in 1991 with the intention of creating software for scientific instruments, but our focus has shifted towards creating tools for developers.
<p>We have worked in close collaborationÂ with <a href="http://www.thermometric.com/">Thermometric AB</a> with some of our products, but now we concentrate on our own tool for the .NET Framework: <b><a href="http://memprofiler.com/">.NET Memory Profiler</a></b>.
<p>We have extensive experience developing using C++, Java and C#.Â Currently, our main development environment is the .NET Framework.Â </p></div>

I'd heard this could be done in Reporting Services 2008 so I tried it and it's easy. I presume others might find simple instructions helpful:

1. In the table where I want to display the column, right-click the cell and chose Create Placeholder....

2. On the General tab (of the new placeholder's properties), set the value to the required column.

3. In the Markup type, choose the option for HTML - Interpret HTML tags as styles

and you're done.

Published Monday, August 25, 2008 12:46 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

	Shannon said: what if you want to leave the markup in there.. and there are table tags in that markup. is there anyway to get the table tags to render? October 8, 2008 11:45 AM
	MartinMiles said: Hey Grey. I read with interest your post on the HTML data representation from SQL in SSRS 2008. I have recently installed SSRS 2008 and don't see the option you mention. i.e. "Create Placeholder..." I am using the "out of the box" SSRS 2008 install from M/S with Business Intelligence Development Studio as the report designer. Could you let me know what I am missing? I'm also interested in Shannon's question on getting the HTML to render as .. well .. HTML! December 15, 2008 7:45 AM
	Greg Low said: Great question. I looked into this and now have the result here: http://sqlblog.com/blogs/greg_low/archive/2008/12/19/rendering-html-in-reporting-services-text-boxes-in-sql-server-2008.aspx December 19, 2008 1:21 AM