Printing multiple records from a query in one 2D Barcode 关注

0

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 评论

0
Avatar
Travis Truax
评论操作 固定链接

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/ 

1
Avatar
Peter Thane
评论操作 固定链接

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.

0
Avatar
AMIT PANDIT
评论操作 固定链接

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

 

请先登录再写评论。