print multiple labels from each recordset 追蹤

0
Avatar
Alex

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?

5 意見

0
Avatar
Raul Soto
評論操作 永久連結

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
Avatar
Alex
評論操作 永久連結

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
Avatar
mohan reddy
評論操作 永久連結

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

Regards:

Mohan

0
Avatar
Pete Thane
評論操作 永久連結

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
Avatar
Adam Flores Sr
評論操作 永久連結

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

 

登入寫評論。