Geek Answers Handbook

Formatting Crystal Reports HTML reports

I'm having problems with special characters in Crystal Reports. I have some data that went in and out of SQL via XML, so some charters were converted to special characters.

For example, and are converted to & and 'are converted to &apos . When data is presented in Crystal Reports with text interpretation set to HTML, it displays & how and how should. The problem I am facing is that &apos does not convert to 'it just stays like &apos .

Does anyone know why it will not convert &apos to '?

Any help would be great.

Thanks in advance.

+4
source share
1 answer

I believe ' is a reference to an XML symbol object, where ' or even ’ for html. I would hope that the html conversion to Crystal Reports could also contain xml characters, but I think not. Note that ' IE does not work. Hope this helps.

For more information, see the following links:

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

HTML code for apostrophe

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

+1
source

More articles:


All Articles