Euro Sign problem in Crystal Reports 11.5
Hi.
I'm running Crytal Reports 11.5 on an Oracle Database.
I have stored an Euro sign (¬) in the table.
When using Sql*Plus or Toad I can see the Euro sign perfectly.
But when I use Crystal Reports 11.5 to view the data, all other text except the Eurosign is shown perfectly, and the eurosign is shown as a small box.
The font in the report is verdana, and the problem still exists if I choose Times New Roman or Arial.
On the Format Editor - Paragraph TAB for the field containing the data, I tried to change the text interpretation to HTML, and the Euro Sign was shown correctly.
But I can not use this setting as all the other text is wronlgy formatted ..
Please help!
//Jacob
I'm running Crytal Reports 11.5 on an Oracle Database.
I have stored an Euro sign (¬) in the table.
When using Sql*Plus or Toad I can see the Euro sign perfectly.
But when I use Crystal Reports 11.5 to view the data, all other text except the Eurosign is shown perfectly, and the eurosign is shown as a small box.
The font in the report is verdana, and the problem still exists if I choose Times New Roman or Arial.
On the Format Editor - Paragraph TAB for the field containing the data, I tried to change the text interpretation to HTML, and the Euro Sign was shown correctly.
But I can not use this setting as all the other text is wronlgy formatted ..
Please help!
//Jacob
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't know.
mlmcc
mlmcc
I assume that you're also doing the printing and exporting from within CR (as opposed to using some other application).
Do you have more than one printer and, if so, have you tried printing on each of them? Are they the same brand/model of printer? If you get the same results on every printer and they're all the same, then it may be a printer driver (or printer) issue. If they're different, that's less likely.
You've posted some seemingly contradictory statements.
In the first message, you said that you can _not_ see the sign when you use CR to "view the data" (which I assume means look at your report on screen), but it is "shown correctly" when you change the field interpretation to HTML.
But then in your second message you said that you _can_ see it "when doing previews" in CR, but not when you print or export.
So, can you see the sign on screen or not? Are "view the data" and "when doing previews" two different things?
Ignoring that question for the moment, it seems odd that changing the field interpretation to HTML got the sign to show correctly (Again, was that on screen or when printing/exporting?). I'm guessing that you don't have HTML tags in that field. I wonder if choosing HTML interpretation affects the font used by CR for the field?
James
Do you have more than one printer and, if so, have you tried printing on each of them? Are they the same brand/model of printer? If you get the same results on every printer and they're all the same, then it may be a printer driver (or printer) issue. If they're different, that's less likely.
You've posted some seemingly contradictory statements.
In the first message, you said that you can _not_ see the sign when you use CR to "view the data" (which I assume means look at your report on screen), but it is "shown correctly" when you change the field interpretation to HTML.
But then in your second message you said that you _can_ see it "when doing previews" in CR, but not when you print or export.
So, can you see the sign on screen or not? Are "view the data" and "when doing previews" two different things?
Ignoring that question for the moment, it seems odd that changing the field interpretation to HTML got the sign to show correctly (Again, was that on screen or when printing/exporting?). I'm guessing that you don't have HTML tags in that field. I wonder if choosing HTML interpretation affects the font used by CR for the field?
James
Good point on the font. It may default to the default browser font.
mlmcc
mlmcc
ASKER
When I say "When I use Crystal reports to view the data", then I mean; Use Crystal to PRINT the outcome of my query. When I use Preview (on screen) or in the Crystal repots program, the Euro Sign is shown correctly. But nevertheless, I have asked the customer to insert EUR instead of the euro sign. Thanks for all the help.
Jacob
Jacob
Thanks for the clarification.
If it displays correctly, but does not print correctly, maybe the problem is in the printer (maybe the font it's using doesn't include that character or something), although I don't know if that would explain getting the wrong character when you export to a PDF file. Have you tried printing on a different printer (in particular, a different printer model)?
If the character coming from the db does not print correctly, but the character inserted in a text field does print correctly, I have to wonder if they're really the same character. If not, one possibility might be to use a formula in CR to replace every occurrence of the character in the db with the character you put in the text field, and then use that formula on the report, instead of the field.
If the character that's put in the db is the same character, but then it doesn't print the same way, perhaps it's being changed somewhere along the way (maybe some setting that affects which character set the db uses). In that case, maybe you could do something to keep the character from being changed.
James
If it displays correctly, but does not print correctly, maybe the problem is in the printer (maybe the font it's using doesn't include that character or something), although I don't know if that would explain getting the wrong character when you export to a PDF file. Have you tried printing on a different printer (in particular, a different printer model)?
If the character coming from the db does not print correctly, but the character inserted in a text field does print correctly, I have to wonder if they're really the same character. If not, one possibility might be to use a formula in CR to replace every occurrence of the character in the db with the character you put in the text field, and then use that formula on the report, instead of the field.
If the character that's put in the db is the same character, but then it doesn't print the same way, perhaps it's being changed somewhere along the way (maybe some setting that affects which character set the db uses). In that case, maybe you could do something to keep the character from being changed.
James
ASKER
If I insert a text box on the report with the euro sign, the euro sign is displayed correctly.
It's when i need to display the uero sign form a field in an oracle database, that I just see a small box instead of the sign (¬) ..
However I can view the sign when doing previews with the build in Crystalviewer in CR11.5.
But when printing directly to a printer or exporting to pdf the sign is showed as the box...
Jacob