Crystal Reports HTML formatting

I am having some issues with special characters in Crystal Reports. I have some data that has come in and out of SQL via XML so some of the charters have been converted to special characters.

For instance & are converted to & and ' are converted to &apos. When the data is represented in Crystal Reports with text interpretation set to HTML it shows the & as & like it should. The problem I am having is that &apos is not being converted to ' it just stays as &apos.

Does anyone have any ide开发者_C百科a why it would not convert &apos to '?

Any help would be great.

Thanks in advance.

I believe that ' is an XML character entity reference where ' or even ’ are for html. I would have hoped the Crystal Reports html conversion might have supported xml characters too, but I guess not. Note that it appears as though ' does not work IE. I hope this helps.

See the following links for more details:

http://en.wikipedia.org/wiki/Character_encodings_in_HTML (1st result in search for "apos" on the page)

HTML code for an apostrophe

http://www.w3schools.com/tags/ref_entities.asp