Removing/Handling HTML characters in Crystal Reports 1

[bjgolden80]

I have a web application that stores data in a Sybase Database. The web application uses the Server.HTMLEncode method to encode characters such as "&" to appear as &. However, in the text fields of my crystal reports, these encoded characters are appearing. Is there any way of handling this ?

Thanks!!

 

[Thadeus]

Can you offer some environment info and some data to go with it?

ex. Crystal 8.5 and the field in the DB appears as: [/code]<b>This is my string field</b>[/code]

I realize this is more simplistic than the html coding you are talking about... it's just an example of what I'd like to see to be able to offer advice.

Thanks,
Thadeus

 

[bjgolden80]

The string is being input to the database as follows:

Server.HTMLEncode("This is the "string", & this is the problem")

In crystal reports I am seeing it as:

'This is the &quot;string&quot;, &amp; this is the problem'

Hope this gives a better idea. The web app is written in ASP, writing to a Sybase Database.

 

[vidru]

You could use formulas to display the field(s). Using the Replace() function, you could handle the above example like this:
[tt]
stringvar t := "This is the &quot;string&quot;, &amp; this is the problem";

t := replace(t, "&amp;","&");
t := replace(t, "&quot;","""");
[/tt]
-dave

 

[Thadeus]

Well, if you have a version of Crystal (I know 9 allows this) that permits HTML interpretation, this is simply a matter of right-clicking on the field, Format Field -> Paragraph tab -> Text Interpretation drop-down -> HTML Text.

~Thadeus