print multiple labels from each recordset

Alex

• July 28, 2017 07:28

Hi, hopefully someone able to give me some idea on how to accomplish this. I have 9 rows of data extracted from mySQL (vbscript) that i would like each of the rows to be on each of the labels, so i should be looking at results of 9 different labels to be printed.

However, i always ended up with the 9th rows of data printed across all the 9 labels. To better illustrate my issue:

My Recordset

row 1 - data 1a, data 1b

row 2 - data 2a, data 2b

    :           :              :

row 9 - data 9a, data 9b

 

I am expecting:-

Label 1 - data 1a, data 1b

Label 2 - data 2a, data 2b

     :               :            :

Label 9 - data 9a, data 9b

 

But it ended up with:-

Label 1 - data 9a, data 9b

Label 2 - data 9a, data 9b

     :               :            :

Label 9 - data 9a, data 9b

 

Any videos or similar tutorials that is able to resolve what i am trying to achieve?

0

• 

  Raul Soto

  ★ BarTender Hero ★

  • August 01, 2017 15:42

  Hello,

  Did you connect to the exported data as a database? Make sure when you print, you set the queried records to all if you want all records in your database to print.

  0
• 

  Alex

  ★ BarTender Hero ★

  • August 11, 2017 08:34

  Hi Raul Soto,

  I didn't use the built-in Connection Database Setup option. I am using VBScript connect through ODBC to MySQL to perform these queries. In this case, how do i have the option to set the queried records to ALL if i want all records to be printed?

  Thanks.

  0
• 

  mohan reddy

  ★ BarTender Hero ★

  • June 07, 2021 08:06

  I am having the same issue, any solutions on this case?

  Regards:

  Mohan

  0
• 

  Peter Thane

  ★ BarTender Hero ★

  • June 07, 2021 13:31

  If you are trying to print the same way using VBScript rather than the inbuilt record selection then I believe you would need to run the print routine for each record and then print that record and then repeat. 

   

  0
• 

  Jose Adam Flores Sr.

  ★ BarTender Hero ★

  • June 08, 2021 19:14

  Hello Alex,

  Since you are using a mySQL script, it is hard for us to imagine what the script looks like

  and how are you connecting your data, since in Bar Tender we use vbScript, there might be

  a comparable solution.

  could you share what the mySQL script looks like, so that any of million of user might be versed in

  mySQL and be able to help.

  There is always the posiblilty that you can export the result of your query to a CSV file and print fro there.

  Regards

   

  0

Please sign in to leave a comment.