Topic: Special Character don't show.... Posted: 06 Nov 2008 at 12:31am
hi everyone im just beginning to learn on how to use Crystal Reports 10 Sage and i have encountered a problem about special characters....
i have a query that uses Mysql database and a sample data is the word "PIÑAS"... the special character Ñ or ñ its alt+164 and alt+165 btw,it won't show properly in the crystal report preview... does anyone know on how to fix this? thanks in advance!
Joined: 14 Aug 2008
Location: United States
Online Status: Offline
Posts: 8
Posted: 07 Nov 2008 at 11:55am
I report out of a SQL database as well and my reports pull exactly what is in the database, even the special characters. I just tried typing alt 164 in a Crystal Text box and it worked fine. What is your data showing in your crystal report?
thanks for the reply, i tried changing the fonts but it still did not work, i also tried by just typing the special character and works fine but when get it from the database it wont show... the Ñ is replaced with an '...do i have to write a code or something to handle this?
i tried even using just times new roman as font but it still did not work, just as i said it works fine when i just use a label and type it in, but i use a query that just displays the record, it show correctly in MySql database but it wont show correctly in crystal
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
as they said...