Thinking out loud here….
When someone orders an item 5 times there is only one line on the order, with a quantity of 5.
But when I want to print labels, I need 5 labels.
I am trying to get a list in excel to use as a merge datasource for a template I created in Word.
How can I replicate the one order line the number of times I need a label?
Is there a way to do that with JetReports?
Every order line can have a different quantity…
Any ideas?
rmw
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Heather,
That is the golden tip!
Thx, works like a charm!
Also thx Teresa, but as you might imagine, I prefer a solution without macro's.
rmw -
Jet Reports Historic Posts Hi,
I'm not sure how to do it with jet reports but you could do it with a macro after the jet report has run:
For loop to go through each line.
Get the value of the quantity off the line.
Another for loop copying the line that many times.
I can help with that if macros aren't your thing. -
Jet Reports Historic Posts why not use a ROWS replicator with SCAN LIMIT?
I'm assuming you are already using one ROWS command to get the order information, so simply nest another ROWS inside that…
EX:
Cell B6 = NL("ROWS=2",your original rows command)
Cell B7 = order number for B6 (or whatever other reference you need for to reference for your datasource)
Cell C7 = Quantity on order
Cell D7 = NL("ROWS","CUSTOMER","NO.",ScanLimit=",C7)
Then continue to replicate your information that you need for your datasource, linking the information from cell B7 so you keep everything on the same line.
NOTE: You'll probably want to put a HIDE command on row 6, because you won't need the data replicated an extra time.
The information in Cell D7 really doesn't matter, it's just used to give you the appropriate number of rows for your report - ScanLimit is designed to give you that number of results, from whatever table you choose to use. I use the customer table, a colleague of mine uses the Item table when he's doing something similar. -
Jet Reports Historic Posts Glad I could help - I know that it's a trick that I was thrilled to discover. We have several reports that are something like "top 20 items sold", and be able to make that number variable has really made my reports much more flexible.
Please sign in to leave a comment.