Solved

Euro Sign problem in Crystal Reports 11.5

Posted on 2009-05-20
7
833 Views
Last Modified: 2012-05-07
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
0
Comment
Question by:pcsdba
  • 3
  • 2
  • 2
7 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24437536
0
 

Author Comment

by:pcsdba
ID: 24449114
Thanks mlmcc, but maybe I haven't been clear enough on my problem.
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
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24450883
I don't know.

mlmcc
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 34

Expert Comment

by:James0628
ID: 24455860
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
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24456428
Good point on the font.  It may default to the default browser font.

mlmcc
0
 

Author Comment

by:pcsdba
ID: 24708924
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
0
 
LVL 34

Expert Comment

by:James0628
ID: 24717074
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
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now