Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Cannot display ampersand sign in a crystal report Post Reply Post New Topic
Author Message
Gian.Rocks007
Newbie
Newbie
Avatar

Joined: 06 May 2013
Location: Philippines
Online Status: Offline
Posts: 1
Quote Gian.Rocks007 Replybullet Topic: Cannot display ampersand sign in a crystal report
     Posted: 07 May 2013 at 2:37pm
I have a crystal report that displays a text with an ampersand (&). I was able to store this text into an oracle database and still displays correctly in my System UI. Unfortunately, when I try to print this one out in a report, the ampersand sign is converted to sharp (#) or a space. And also, when the text is converted to a barcode, same thing happens. I was wondering why is this happening? Thanks for the usual support.
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 08 May 2013 at 1:17am
Hi

Can you change the font in crystal and see what it is printing. Because some times '-' prints as small box when you use Arial as font.

If not try to place this text in single or double quotes and check.
Thanks,
Sastry
IP IP Logged
bwsanders
Senior Member
Senior Member


Joined: 05 Sep 2012
Location: United States
Online Status: Offline
Posts: 177
Quote bwsanders Replybullet Posted: 08 May 2013 at 1:58am
& is the crystal syntax for concatenation. you will need to put the & in double quotes to tell crystal it's not to be used as code.
IP IP Logged
Printable version Printable version

Forum Jump
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