Skip to Content
0

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

Oct 16, 2017 at 06:23 AM

59

avatar image

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

10 |10000 characters needed characters left characters exceeded

Screen shot attached FYR.

6ulny.png (174.4 kB)
0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ido Millet Oct 16, 2017 at 12:22 PM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

If you are not allowed to create a REPEATER table, there are alternative solutions...

0

please give the alternative solution

0

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).

0