Skip to Content

Printing multiple labels based on a quantity field on Goods issue Table

Hi Expert,

How to generate Printing multiple labels based on a quantity field on Goods issue Table.

please describe how it is possible ,if you have any query (loop Query) please share for idea.

Thanks

Danish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 16, 2017 at 12:22 PM

    Create a "REPEATER" table with a single column (How_Many) that looks like this:

    How_Many
    1
    2
    3
    4
    5
    6
    etc.

    Now, in your report, add the Repeater Table and add a join or record selection condition of:
    Order.quantity >= Repeater.How_Many
    This would cause each order to be duplicated as many times as the value of {Order.quantity}.

    If you need to print "N of M" modify the repeater table to look like this, and use an equal join:
    N M
    1 1
    2 1
    2 2
    3 1
    3 2
    3 3

    hth,
    - Ido

    Add comment
    10|10000 characters needed characters exceeded

    • 1. Multiple detail sections (Da, Db, ...) with suppress conditions.
      - or -
      2. 3rd-party tool (at least one such tool can automatically print the desired number of copies based on a Crystal field or formula).