Barcode printing on a "label type" Report

Comments

• Options

  Savatage Member Posts: 7,142

  2005-05-17

  Now this doesn't generate the actual code .. i used barcode magic to create a little BMP.
  
  or http://www.mibuso.com/dlinfo.asp?FileID=106
  

  ---

  
  We upc code some items we carry & print sheets of barcode labels
  100 on a sheet - 5 columns - 20 rows. (1.5x.5inch labels)
  
  for example
  the Item table has a field called Picture. We don't use the picture field so we used it to store that item's Barcode BMP.
  (note..you could always create a new "BLOB" field in the item table)
  
  Item->picture->import.
  
  now on the report you add a "Picture Box" & change the SourceExp to "Picture".
  
  (this is assuming your report's dataitem is "ITEM")
  
  When you run the report for that item # it's barcode pic will show.
  now you just have to setup the sizes & locations of the fields to fit on the label sheet.
  
  Hope that made sence..play around with it.

  Harry Ruiz
  http://www.BiloBeauty.com
  http://www.autismspeaks.org

  0
• Options

  emkpro Member Posts: 47

  2005-05-18

  Savatage wrote:

  
  We upc code some items we carry & print sheets of barcode labels
  100 on a sheet - 5 columns - 20 rows. (1.5x.5inch labels)
  
  for example
  the Item table has a field called Picture. We don't use the picture field so we used it to store that item's Barcode BMP.
  (note..you could always create a new "BLOB" field in the item table)
  
  Item->picture->import.
  
  now on the report you add a "Picture Box" & change the SourceExp to "Picture".
  
  (this is assuming your report's dataitem is "ITEM")
  
  When you run the report for that item # it's barcode pic will show.
  now you just have to setup the sizes & locations of the fields to fit on the label sheet.
  
  Hope that made sence..play around with it.

  
  How do you print more than one barcodes ("Item.Picture" for your example) in a row for your label ???

  //EMK\\

  0
• Options

  Savatage Member Posts: 7,142

  2005-05-18

  for us it was easy - we did something like this.
  
  Pic:
  http://www.geocities.com/navision_attai ... ortPic.JPG
  Result:
  http://www.geocities.com/navision_attain/test.pdf
  Fob:
  http://www.geocities.com/navision_attai ... Report.zip
  
  top Left box is a very small "Item No."
  top Right box is very small "item Description"
  Large Box Underneath both is the picture box that holds the UPC Code pic.
  & I just repeated the fileds over and over till it filled the page.
  
  Now we just enter the item # we want & we get a sheet of barcode labels or as many sheets as you want by selecting the number of copies in the printer selection dialog box.

  Harry Ruiz
  http://www.BiloBeauty.com
  http://www.autismspeaks.org

  0
• Options

  emkpro Member Posts: 47

  2005-06-07

  Savatage wrote:

  
  top Left box is a very small "Item No."
  top Right box is very small "item Description"
  Large Box Underneath both is the picture box that holds the UPC Code pic.
  & I just repeated the fileds over and over till it filled the page.
  
  Now we just enter the item # we want & we get a sheet of barcode labels or as many sheets as you want by selecting the number of copies in the printer selection dialog box.

  
  Nice job, but i think I am misunderstood. If you have to print different Bar codes in a sheet or in a row can you handle that using pic. approach.

  //EMK\\

  0
• Options

  Savatage Member Posts: 7,142

  2005-06-07

  this example was for a full sheet.
  
  but if i set the page up for 1 row instead of 20 - then the next row would print out the next item # I selected.
  
  So using this example modified to 1 row I can get 20 rows of labels each with a different upc code. (each row will give you 5 of the same tho)
  
  Not sure what you're looking for?

  Harry Ruiz
  http://www.BiloBeauty.com
  http://www.autismspeaks.org

  0
• Options

  tatie Member Posts: 16

  2005-07-27

  Hello
  
  How do you print different barcodes one after the other on two row for label? and display only barcode not text of my picture
  
  Thank

  0
• Options

  aztecconsulting Member Posts: 55

  2005-07-27

  Not to throw this thread off track but we used font software to get out barcodes. With the barcode font installed, the report just changes the font on the field if I need different symbology.
  
  http://www.waspbarcode.com/software/fontware.asp

  0