ugh first major crystal to reporting services snag...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Smokey Grindle - 31 Jan 2007 13:13 GMT

Ok this is a big snag... in crystal reports you can translate RTF and HTML
fields into your report... so we had a very large table with values stored
as HTML in a single field... its not full html, just formatting markup like
 etc... in crystal it would preserve these formatting, in reporting
server it just prints the field like this is my BOLD field
which makes it look ugly on the report, heck i'd just take the plain text if
i could get the tags out of it!... any suggestions on what to do? thanks!

Reply to this Message

Bruce L-C [MVP] - 31 Jan 2007 14:41 GMT

To strip off the html I believe there is a framework function that you could
use. Set the value of the textbox to an expression like this:

= Code.StripHTML(Fields!Fieldname.value)

You would write the function StripHTML that would return the value with the
html striped.

This link shows how to do this using regular expressions.

http://weblogs.asp.net/rosherove/archive/2003/05/13/6963.aspx

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Ok this is a big snag... in crystal reports you can translate RTF and HTML
> fields into your report... so we had a very large table with values stored
[quoted text clipped - 4 lines]
> plain text if i could get the tags out of it!... any suggestions on what
> to do? thanks!

Reply to this Message