Solved

Euro Sign problem in Crystal Reports 11.5

Posted on 2009-05-20
7
835 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Group Header Repeating on every page 4 45
Crystal Reports--specifying a specific detail row to select 2 54
Need to learn crystal reports 7 69
Crystal Reports 13 5 59
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. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

777 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