Box label qty divided by box qty

Peter Hrdy

• November 07, 2019 12:01

Hello 
I need help

I am trying to chreate Box Label by getting data from SQL DB

In DB i have Total QTY and box QTY 
I need  to divide Total QTY by box QTY

example 
Total QTY 120 

box QTY 25

this means i need to print 5 label total 

4 with 25qty and 1 label with 20qty 

how can i do this 

0

• 

  Mike Wright

  ★ BarTender Hero ★

  • November 11, 2019 16:36

  Use Named Data Sources and Visual basic scripts.

  Named Data Source: QTY, Type Number

  Named Data Source: TotalQTY, Type Number

  Named Data Source: Result, Type Visual Basic Script

  Visual Basic Script: Single-Line Expression

  Format.NamedSubString("TotalQTY").Value / Format.NamedSubString("QTY").Value

   

   

  0

Please sign in to leave a comment.