Box label qty divided by box qty Follow

0
Avatar
Peter Hrdy

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 

1 comments

0
Avatar
Mike Wright
Comment actions Permalink

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

 

 

Please sign in to leave a comment.