Solved

Euro Sign problem in Crystal Reports 11.5

Posted on 2009-05-20
7
830 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 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

10 Experts available now in Live!

Get 1:1 Help Now