Printing multiple records on a single sheet with query prompt
I have a label template that uses a query prompt to select a sku record from my db and print on a zebra printer. It works just fine.
I want to do a similar process, same template but print on 8.5x11" letter paper, my stock happens to have 8 labels per page, 2 columns, 4 rows. Where I used to have one query prompt for one record, I now want to be able to select 8 records at a time and only print the job once I have selected the 8 records.
My page setup appears to be all good, I just can't figure out how to set up a query prompt or prompts that prints 8 different skus in succession on one letter sized sheet
I have tried many angles and have browsed many help files but have not landed on success. There must be a way.
-
It sounds like you may need to use a Record Picker table instead unless you can adjust the Prompt in some way to make it pick out the records you want to include, perhaps searching on a different parameter or using a Contains instead of an Equals for example
0 -
Thanks for the reply Peter, I'm getting closer. I found that my database setup Filter was set to AND when it should have been OR. So now I have my 8 query prompts set up in the form and it will print the 8 labels in succession on the page. My query prompts are using Autocomplete from Query Prompt Values rather than record picker right now because it is seems to be easier for user entry.
Which leads to my next problem...Because of this OR filter, if I enter the same sku into two different query prompts, that sku will only print one label when I want it to print on two. It is printing one label for each unique sku value. How do I adjust my Filter to recognize that if a query prompt sku value is entered twice, that it should print 2 copies of the same label?
In below screenshot, there are 6 unique values, so it will print only 6 labels.
0 -
I dont think you can do it that way, as all the values would need to be unique.
It looks to me like you need to go down the Record Picker table route, with a quantity selector field and select the items you want the number of each on there
0
請登入寫評論。
評論
3 條評論