Printing multiple records from a query in one 2D Barcode 关注
Hello,
One of our customers need to print a packing list with al the UPC Codes of a production order concatenated into a one 2D QR barcode . I'm having a bad time trying to figure it out how to do it since I can only get the first record of the Query.
Any idea of how could I do it with Bartender 2016? Any example to use visual basic? or maybe a clue?
Thank you!!!
3 评论
You haven't explained what DB you're using, but here's a tactic you could employ to achieve this:
https://www.sqlshack.com/multiple-options-to-transposing-rows-into-columns/
In 2016 you can only query one record at a time, but a function has been added in 2019 to achieve this using the Records Per Item property page on the Database Setup dialog I understand from the information that has recently been released about this new version.
01 | LEVEL | 01 | 01 | BA010101 |
01 | LEVEL | 01 | 02 | BA010102 |
01 | LEVEL | 01 | 03 | BA010103 |
01 | LEVEL | 02 | 01 | BA010201 |
01 | LEVEL | 02 | 02 | BA010202 |
01 | LEVEL | 02 | 03 | BA010203 |
01 | LEVEL | 03 | 01 | BA010301 |
01 | LEVEL | 03 | 02 | BA010302 |
01 | LEVEL | 03 | 03 | BA010303 |
01 | LEVEL | 04 | 01 | BA010401 |
01 | LEVEL | 04 | 02 | BA010402 |
I WANT TO 3 QR CODE BARCODE IN SAME TEMPLET BUT DATA VERIBLE
请先登录再写评论。