Crystal Reports Ascii Character

Yahoo Archive
1
ChrW() returns the unicode value whereas chr() gives ASCII. I'm not exactly sure on the exact differences but obviously there are some or they wouldn't have two character sets. Just make sure you use the one that gives the value you're looking for. And if you're not sure on what the ASCII character is, you can use the Asc() function (or AscW() for unicode.) You can find a table of ASCII on Wikipedia (use the decimal column):

http://en.wikipedia.org/wiki/ASCII

E.g. totext(trim(ASC("#")),2) returns 35 and chr(35) returns #.

Full example for the barcode formula:

"*" + field1 + chr(35) + field2 + "*" returns *field1#field2*

Hopefully the character isn't an asterisk.


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Which ASCII character?
>
> In Crystal Reports, hit F1 and look up the ChrW() function.
>
>
>
> Vic
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of tomrippity02
> Sent: Monday, August 03, 2009 5:58 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Reports Ascii Character
>
> I have a barcode that is made up of two dataset fields and I need to
> insert an ascii character in between them to use as a delimiter.
>
> The Datawedge software that I am using requires that I pass it the ascii
> character so my question is.. How do I insert Ascii between two fields?
>
> Aaron
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
2
I have a barcode that is made up of two dataset fields and I need to insert an ascii character in between them to use as a delimiter.

The Datawedge software that I am using requires that I pass it the ascii character so my question is.. How do I insert Ascii between two fields?

Aaron
3
Which ASCII character?

In Crystal Reports, hit F1 and look up the ChrW() function.



Vic


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of tomrippity02
Sent: Monday, August 03, 2009 5:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Ascii Character

I have a barcode that is made up of two dataset fields and I need to
insert an ascii character in between them to use as a delimiter.

The Datawedge software that I am using requires that I pass it the ascii
character so my question is.. How do I insert Ascii between two fields?

Aaron



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links