If statements for a database field
I have a label that I am attempting to create with SQL integration. There's a field on the label where I will need the quantity but on certain items, the quantity is on a different field. Is there a way to use an if statement or any method to pull the correct field into the db field on to the label?
0
-
I would suggest you pull the values from both fields onto the label template (they don't need to print) and then either use a VB script routine to determine which one prints or else use Suppression to print just the field you want. The latter would depend on your data and you could concatenate the fields together and then apply the suppression rules to the two substrings
0
Please sign in to leave a comment.
Comments
1 comment