Count the volumes by total quantity to be printed

Issues related to label design (working with databases, data processing, RFID encoding etc.) and printing (from NiceLabel Express, NiceLabel Pro, NiceForm and NicePrint)

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
rbaptista
Enthusiast
Posts: 15
Joined: Mon Aug 26, 2019 11:12 am

Count the volumes by total quantity to be printed

Post by rbaptista » Fri May 14, 2021 3:35 pm

Good afternoon,

I intend to count the volumes by total quantity to be printed from a table in sql, however when I use the internal variables of Request quantity and Totalquantityprinted, the request quantity fetches the total value of the lines in the table, and not the filtered field. If you select the quantities by hand, the request assigns the correct value.
Does anyone know how to solve this problem?
The idea would be to have 120 pages to print it assign 1/120, 2/120, 3/120 ...
Attachments
3.jpg
3.jpg (49.6 KiB) Viewed 232 times
1.jpg
1.jpg (82.19 KiB) Viewed 233 times

User avatar
Mytch
NiceLabel Support
NiceLabel Support
Posts: 212
Joined: Fri Jul 13, 2018 10:26 pm
Location: Milwaukee, Wisconsin
Contact:

Re: Count the volumes by total quantity to be printed

Post by Mytch » Tue May 18, 2021 7:08 pm

rbaptista,

Internal Variable RequestedQuantity is only providing the value of your print quantity - not the sum of copies defined by the database. In this case, functionality is working as designed. When print quantity is 40, RequestedQuantity will display 40. When Unlimited, 2147483647 is displayed (int32 max). Unlimited quantity is used by default, because this will print all the selected records and defined copies without manually update the quantity.

You can suggest a New Idea here if you would like a new Internal Variable for something like "requested copies":
viewforum.php?f=12

Regards,
Mytch

rbaptista
Enthusiast
Posts: 15
Joined: Mon Aug 26, 2019 11:12 am

Re: Count the volumes by total quantity to be printed

Post by rbaptista » Fri May 21, 2021 10:11 am

Thanks Mytch, but
Can you do that with a function? Like, add the quantities to print that are selected at the time of printing? can you help?

User avatar
Mytch
NiceLabel Support
NiceLabel Support
Posts: 212
Joined: Fri Jul 13, 2018 10:26 pm
Location: Milwaukee, Wisconsin
Contact:

Re: Count the volumes by total quantity to be printed

Post by Mytch » Wed Jun 02, 2021 11:47 pm

rbaptista,

Sorry for the delayed response. Unfortunately, there is no script or function that can resolve this problem. The copies per record is not exposed in any Internal Variable, as discussed, so it is not possible to add the values from each record at print-time. Product Management team checks for New Ideas here:
viewforum.php?f=12

Some request for this already might exist, but I couldn't find anything.

Regards,
Mytch

Post Reply