BarCodes in Report Builder

It worked! Thanks allot to all who helped, I'm very glad I'm in this group.

Jim Horton
Mol-Son, Inc.

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, November 01, 2002 4:30 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BarCodes in Report Builder


Use the STRING funciton to change numerics to String such as:
'*' + STRING(JobOper.AssemblySeq,'9999') + '*'
The 9999 should be the same as the field size. For bar codes I use the 9
format to get leading zeros. Using >>>> as the formatting would put spaces
in the bar code.
-Todd C.


-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Friday, November 01, 2002 3:19 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BarCodes in Report Builder


That works for JobHead.JobNum which is a "Char", but AssemblySeq and OprSeq
are "Inte" and it does not work. Or is it just me?


Jim Horton

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, November 01, 2002 11:28 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BarCodes in Report Builder


In RB I concatenate strings by using the plus sign +. Such as '*' +
JobHead.JobNum + '*" to put the asteriks on the job number and make it bar
code scanable (in Code 39).
-Todd C.

-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Friday, November 01, 2002 10:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BarCodes in Report Builder


I was getting help form epicor, and to be able to make JobOper.AssemblySeq a
barcode.
they told me "You need to cantonate a formula" *||field||*
Then once this formula is in your report you need to highlight it and change
the font.
Does anyone know how to cantonate a formula in beginner terms.

Thank You Very Much

Jim


Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17050071
>
83:HM/A=1267611/R=0/*
http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
<http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=>
300x250;ord=1036167051089701?>

<
http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
<http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
>
l/S=:HM/A=1267611/rand=747958003>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .




[Non-text portions of this message have been removed]



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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1036185559093437?>

<http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
l/S=:HM/A=1267611/rand=896502587>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]



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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
I was getting help form epicor, and to be able to make JobOper.AssemblySeq a barcode.
they told me "You need to cantonate a formula" *||field||*
Then once this formula is in your report you need to highlight it and change
the font.
Does anyone know how to cantonate a formula in beginner terms.

Thank You Very Much

Jim
In RB I concatenate strings by using the plus sign +. Such as '*' +
JobHead.JobNum + '*" to put the asteriks on the job number and make it bar
code scanable (in Code 39).
-Todd C.

-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Friday, November 01, 2002 10:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BarCodes in Report Builder


I was getting help form epicor, and to be able to make JobOper.AssemblySeq a
barcode.
they told me "You need to cantonate a formula" *||field||*
Then once this formula is in your report you need to highlight it and change
the font.
Does anyone know how to cantonate a formula in beginner terms.

Thank You Very Much

Jim


Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1036167051089701?>

<http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
l/S=:HM/A=1267611/rand=747958003>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
That works for JobHead.JobNum which is a "Char", but AssemblySeq and OprSeq are "Inte" and it does not work. Or is it just me?


Jim Horton

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, November 01, 2002 11:28 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BarCodes in Report Builder


In RB I concatenate strings by using the plus sign +. Such as '*' +
JobHead.JobNum + '*" to put the asteriks on the job number and make it bar
code scanable (in Code 39).
-Todd C.

-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Friday, November 01, 2002 10:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BarCodes in Report Builder


I was getting help form epicor, and to be able to make JobOper.AssemblySeq a
barcode.
they told me "You need to cantonate a formula" *||field||*
Then once this formula is in your report you need to highlight it and change
the font.
Does anyone know how to cantonate a formula in beginner terms.

Thank You Very Much

Jim


Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1036167051089701?>

<http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
l/S=:HM/A=1267611/rand=747958003>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]



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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Use the STRING funciton to change numerics to String such as:
'*' + STRING(JobOper.AssemblySeq,'9999') + '*'
The 9999 should be the same as the field size. For bar codes I use the 9
format to get leading zeros. Using >>>> as the formatting would put spaces
in the bar code.
-Todd C.


-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Friday, November 01, 2002 3:19 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BarCodes in Report Builder


That works for JobHead.JobNum which is a "Char", but AssemblySeq and OprSeq
are "Inte" and it does not work. Or is it just me?


Jim Horton

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, November 01, 2002 11:28 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BarCodes in Report Builder


In RB I concatenate strings by using the plus sign +. Such as '*' +
JobHead.JobNum + '*" to put the asteriks on the job number and make it bar
code scanable (in Code 39).
-Todd C.

-----Original Message-----
From: Jim Horton [mailto:jim.horton@...]
Sent: Friday, November 01, 2002 10:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BarCodes in Report Builder


I was getting help form epicor, and to be able to make JobOper.AssemblySeq a
barcode.
they told me "You need to cantonate a formula" *||field||*
Then once this formula is in your report you need to highlight it and change
the font.
Does anyone know how to cantonate a formula in beginner terms.

Thank You Very Much

Jim


Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17050071
>
83:HM/A=1267611/R=0/*
http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
<http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=>
300x250;ord=1036167051089701?>

<
http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
<http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
>
l/S=:HM/A=1267611/rand=747958003>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .




[Non-text portions of this message have been removed]



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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>




Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1036185559093437?>

<http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
l/S=:HM/A=1267611/rand=896502587>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]