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