sql server reporting services: how to render HTML fields in report -- sql server reporting services

how to render HTML fields in report

Toni Pohl
5/14/2006 12:00:00 AM

sql server reporting services: Hi all,

I´ve a table with a memo field which contains HTML-Code (tables, links,
images, etc) and a report that prints these fields.

When the report prints this field, the HTML-content is rendered as text,
e.g. "<table><tr><td><p>text</p>.....".

Is there _any_ way that rs can render the HTML fields??
(Or that I prerender the HTML-content somehow so that rs generates the
correct output as a browser would do, or whatever...?)

I found only a suggestion "Add an Internet Content Control for embedding
HTML" here:
....Reporting Services is missing the ability to embed web pages into its
reports....
http://www.ssw.com.au/ssw/Standards/BetterSoftwareSuggestions/ReportingServices.aspx#InternetContent

Has anybody an idea how to solve this?

Thanks for any tips!
Toni

RE: how to render HTML fields in report

Bava Mani
5/15/2006 8:09:01 AM

Hi,
you cannot embed HTML code in text field.
The report layout is not designed to embed the HTML code.
There is a option to Naviage to a HTML page. (Jump To Url action on a text
field ) you can write a javascript to open a web page and show the HTML code
there.. the javascript code can be like this
="javascript:void(window.open(document.write('" & Fields!text12.Value &
'"),'_blank'))"

let us know how it goes.

Thanks
Bava

[quoted text, click to view]

Re: how to render HTML fields in report

Toni Pohl
5/18/2006 12:00:00 AM

Hi Bava,

well, thank you.
But I really need the formatted field output in the report (and the text
only output with RegEx I tried is not enough, because there are a lot of
tables a.s.o. included).
The only workarounds I found are creating pictures of the html-content and
to show these (poor quality).
So I think I still need to generate Word HTML files instead of reports
(which I thought and hoped will be obsolete with rs)...
However, it seems, there is no workaround. But thanks again for your tip.

Thanks,
Toni

"Bava Mani" <BavaMani@discussions.microsoft.com> schrieb im Newsbeitrag
news:264937EF-CCCD-4850-B23F-DAC0A78E76E7@microsoft.com...
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.