Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Convert number to ascii text Post Reply Post New Topic
Author Message
jlindquist23
Newbie
Newbie
Avatar

Joined: 06 Jun 2019
Location: United States
Online Status: Offline
Posts: 5
Quote jlindquist23 Replybullet Topic: Convert number to ascii text
    Posted: 10 Aug 2022 at 3:22am
How can I convert to ascii text?
This is what I tried, but the command of BinaryCharConversion is not accurate.

BinaryCharConversion(totext({JT_WorkTicketWrk.ParentQtyOrdered},0,""),'binary')

Any idea how to convert the ParentQtyOrdered field to ascii?

Thanks@
Thanks,
Jennifer
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 10 Aug 2022 at 4:01am
Ascii text?  I have never heard of that term.  Thus I am not sure what you are trying to achieve.  Converting individual characters to the ascii value can be done.  Crystal Reports has a function called AscW which will return the unicode of character.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 23 Aug 2022 at 7:28am
If you want to display the ParentQtyOrdered number as a string, you would use the ToText() formula like this:

ToText({ParentQtyOrdered}, 0)

If you want to display the number as words, you would use a formula like this:

ToWords({ParentQtyOrdered})

If you want the ASCII value of the number (which doesn't make sense here...) you would write the formula like this:

Chr({ParentQtyOrdered})

-Dell
IP IP Logged
jlindquist23
Newbie
Newbie
Avatar

Joined: 06 Jun 2019
Location: United States
Online Status: Offline
Posts: 5
Quote jlindquist23 Replybullet Posted: 23 Aug 2022 at 9:06am
I got it to work! Thanks friends!
Thanks,
Jennifer
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.016 seconds.