Printing Upc Barcode In A Paragraph Style Similar To Text S’abonner

0
Avatar
Legacy Poster

I have shipping document that has detail row information on the product shipping.  Those fields have the paragraph checked since the query can return multiple rows.  Now I would like to modify that bartender document to include a UPC barcode for each product listed on the paragraph.  Do i make an additional query from the product data in the "paragraph" or can in programatically create the paragraph of the UPC barcodes to match the lines in product information in the paragraph?

 

So for each item# I would like to have a UPC print in the attached format.  The QTY, Item and Description are all text with a paragraph checked.

 

 

 

4 commentaires

0
Avatar
Domingo Rodriguez
Modérateur
Actions pour les commentaires Permalien

Could you also attach your BarTender document (.btw) and database file for us to examine?

 

From your question, I'm not sure if for each printed label you want the UPC bar code to show a different value from the database, something which is the default behaviour for BarTender when reading from a variable data source (the default behaviour is to print 1 label per database record)...

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

Here are is my BTW file and the sql files from SQL Server that are returning my rows for the BTW.  The header query returns the customer and pallet information and the detail query returns the information about each specific product on the pallet.

 

The sample mockup shows the header information, the header uses the lbl_ShipPallet query and it returns 1 row

  • Route
  • Trailer
  • Account number and description
  • Shipping Date
  • Pallet Number
  • Picker Name

The detail Query is formated with a paragraph objects. The detail query is lbl_ShipPalletDetails and returns many rows

  • Product
  • Quantity
  • Product Description

The end desire is to print a UPC barcode for each product listed in the detail query.

 

[attachment=598:lbl_ShipPallet.sql.txt]

[attachment=599:lbl_ShipPalletDetails.sql.txt]

[attachment=600:SampleSalemShippingLabelV4.jpg]

[attachment=601:Shipping Label.btw]

0
Avatar
Legacy Poster
Actions pour les commentaires Permalien

What about using VB script to filter the data to the proper UPC barcode? 

 

If I define 10 UPC barcodes on the label as shown in the previous post and write a VB script to determine which row to print the correct UPC.  My query returns 10 records, I add a column called "Rows" to match which record to print for each of the 10 different UPC barcodes defined.  See the example VB script for label number 5.  The default for all UPC labels would need to be Not Visable, that way if no data is passed or is null then nothing would print.

 

Row Item Qty Description UPC
1 457124 2 Catalog Number 1234567890
2 100032 1 Catalog Number 1234567890
3 100038 1 Catalog Number 1234567890
4 100298 2 Catalog Number 1234567890
5 100298 1 Catalog Number 1234567890
6 100298 1 Catalog Number 1234567890
7 100298 2 Catalog Number 1234567890
8 100298 1 Catalog Number 1234567890
9 100298 1 Catalog Number 1234567890
10 100298 1 Catalog Number 1234567890
    
    
"if field(""Row"") = 5 then"    
   UPClabel5.text=field(UPC)    // can this even be done in VB script?
   UPClabel5.visable=1    
end   

0
Avatar
Domingo Rodriguez
Modérateur
Actions pour les commentaires Permalien

Vous devez vous connecter pour laisser un commentaire.