A barcode is just text, and the barcode font is just a font.
Crystal doesn't know what control codes are, so you will have to append those characters to the string that eventually prints out as a barcode.
Luckily this isn't difficult at all, no matter what some vendors want you to think.
As long as each client that will print a barcoded report has the DWBAR39.ttf font installed, you have all you need right there. That font is included with Vantage.
Using that original example I gave, you'd make a Formula Field in Crystal along lines of:
"*" + {recordset.jobnum} + "$I" + cstr({recordset.asm}) + "$I" + cstr({recordset.oprseq}) + "$I*"
(note: both the assembly and the oprseq are numerical, so must convert them to text before concatenating them in to a string)
Place it on the report, set its font to DataWorks Bar 39
Also, make sure your scanner has been programmed to read Full ASCII Code 39. This lets it see the $I as the code for a 'tab'.
Voila. you're done.
----- Original Message ----
From: brad_boes <bboes@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 2, 2008 11:54:02 AM
Subject: [Vantage] Re: Barcode Scanning and MES 8.03.403D
We are implementing 8.03.404b with MES and are also running into
similar "opportunities" to streamline various multi-step entry
points with one combined barcode.
How are you generating the barcode? Has anyone gotten Crystal to do
the needed control codes?
Thanks.
Brad Boes
Crystal doesn't know what control codes are, so you will have to append those characters to the string that eventually prints out as a barcode.
Luckily this isn't difficult at all, no matter what some vendors want you to think.
As long as each client that will print a barcoded report has the DWBAR39.ttf font installed, you have all you need right there. That font is included with Vantage.
Using that original example I gave, you'd make a Formula Field in Crystal along lines of:
"*" + {recordset.jobnum} + "$I" + cstr({recordset.asm}) + "$I" + cstr({recordset.oprseq}) + "$I*"
(note: both the assembly and the oprseq are numerical, so must convert them to text before concatenating them in to a string)
Place it on the report, set its font to DataWorks Bar 39
Also, make sure your scanner has been programmed to read Full ASCII Code 39. This lets it see the $I as the code for a 'tab'.
Voila. you're done.
----- Original Message ----
From: brad_boes <bboes@...>
To: vantage@yahoogroups.com
Sent: Tuesday, September 2, 2008 11:54:02 AM
Subject: [Vantage] Re: Barcode Scanning and MES 8.03.403D
We are implementing 8.03.404b with MES and are also running into
similar "opportunities" to streamline various multi-step entry
points with one combined barcode.
How are you generating the barcode? Has anyone gotten Crystal to do
the needed control codes?
Thanks.
Brad Boes
--- In vantage@yahoogroups .com, "ting.danny" <ting.danny@ ...> wrote:
>
> Thanks Tony
>
> I will give that a go.
>
> Danny
>
>
> --- In vantage@yahoogroups .com, Tony Hughes <thughes281@ > wrote:
> >
> > Hi Danny,
> >
> > Don't know that scanner exactly, but I know how to do JOB + tab
+ ASM + tab + OPR + tab all in one nice barcode
> >
> > here's what your barcode will look like, *JOB1234$I0$ I30$I*
> > where Job is JOB1234 and Asm is 0 and Oper is 30.
> >
> > The trick with the 'tab' is that you have to enable Full ASCII
for Code 39 on your scanner. This allows you to put that $I in your
> barcode as a 'tab'
> >
> > Tony
> >
> >
> > ----- Original Message ----
> > From: ting.danny <ting.danny@ >
> > To: vantage@yahoogroups .com
> > Sent: Friday, August 29, 2008 12:58:23 AM
> > Subject: [Vantage] Barcode Scanning and MES 8.03.403D
> >
> >
> > Hi All
> >
> > We are looking at using barcodes to scan in job/asm/op into MES
> using
> > one barcode rather than scanning in job, asm, and op seperately.
We
> > cannot however work out how to get it to tab to the next field
> after
> > the job number and then 'ok'. Does anyone have any experience
using
> the
> > PSC QS6000 Plus scanner? Any advice would be very much
appreciated.
> >
> > Danny
[Non-text portions of this message have been removed]