Solved

Euro Sign problem in Crystal Reports 11.5

Posted on 2009-05-20
7
837 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
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Reports  Formula to Command 4 88
Exporting Crystal report withh dynamic image in C# 5 69
Crystal Report for VS2013 17 132
free Crystal Report viewer 4 26
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

829 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