Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2005
    Posts
    9

    Unanswered: Barcode Printing

    Hi

    I have a report tha print quantity and Barcode number

    How I can make this report to print so many times the
    Barcode number as is the value of quantity?

    For example if the quantity is 4 and the Barcode number is 1234567890123
    Then I want to print 4 labes with the Barcode number 1234567890123

    Label 1 --> 1234567890123
    Label 2 --> 1234567890123
    Label 3 --> 1234567890123
    Label 4 --> 1234567890123

    Thank you.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Where's your data coming from?
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2005
    Posts
    9
    From SQL Server

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Create a numbers table (example script here: http://gvee.co.uk/files/sql/dbo.numb...o.calendar.sql)

    Code:
    SELECT barcodes.barcode
         , barcodes.quantity
    FROM   dbo.barcodes
     INNER
      JOIN dbo.numbers
        ON numbers.number BETWEEN 1 AND barcodes.quantity
    Voila!
    George
    Home | Blog

  5. #5
    Join Date
    Jun 2005
    Posts
    9
    I cant use that because the lines cames from invoice

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You can't modify the source query?
    George
    Home | Blog

  7. #7
    Join Date
    Jun 2005
    Posts
    9
    Exactly

    It is from ERP sytem.

    I must do it from the report thats the only I can change.

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •