Database query Folgen

0
Avatar
Dave Ingram

I have a single database that includes multiple barcode symbologies. EAN13 ITF14 and EAN128

Is there anyway to change the barcode symbology depending on barcode type , or should I have separate label layouts and then how do I limit the data available?

    

4 Kommentare

0
Avatar
Pete Thane
Aktionen für Kommentare Permalink

How is the data stored, ie are the barcodes all in the same field/column of the database? 

0
Avatar
Pete Thane
Aktionen für Kommentare Permalink

...sorry forgot to add, if in separate columns, is there only data in one of the barcode columns for each item?

0
Avatar
Dave Ingram
Aktionen für Kommentare Permalink

All barcodes in the same column , and therefore 1 item per row.

0
Avatar
Pete Thane
Aktionen für Kommentare Permalink

There a couple of ways you could achieve this all of which would need some form of conditional printing, all of which would work in very a similar fashion

  1. Three barcodes on the same label each set to only print in certain circumstances (length of the barcode in the database)
  2. Multiple layers on the the same template
  3. Multiple templates on the same label

2 and 3 are quite similar and you would basically setup a different label for each type of barcode either as a layer or a template and set up the conditional printer accordingly and with each a top layer/template would be needed either that does not print or that has all the other label fields that are common to each label. To this top layer/template you would need to add a field that counts the number of characters in your barcode field (see below).

Option 1 is probably the simplest way to set this up and for this you would need to add the three barcode symbols onto your label template and use the Print When button accessed by clicking on the name of the barcode (the Barcode1 in the image below). As with options 2 and 3 too, you would also need to add a VB Script > Event Controlled> OnNewRecord text field (off to the side of the label so it wont actually print. This field should be given a name via the Change Data Source Name button and VB script should be something like this

Value = <Database field selected from the Database Fields option in the Script Assistant in the column to the right)

Value = Len(Value)

To set the name use the button ringed below:

As you can see I called my field BCodeLen.

Below is a sample of the conditional printing with this one being for the EAN-13 symbol, the ITF equals should be 14 and for the GS!-128 see the 2nd image below.

I hope this helps

Pete

 

(NOTE: the Or is now and And - click on the word to change it)

 

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.