Printing Upc Barcode In A Paragraph Style Similar To Text
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.
-
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 -
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 -
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
end0 -
Are you perhaps looking to print data from multiple database records onto just one label?
If yes, then the below topics will help:
0
Please sign in to leave a comment.
Comments
4 comments