If statements for a database field

Ivan Burden

• 2023年06月27日 14:51

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

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2023年06月27日 18:37
  • 已编辑于

  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

请先登录再写评论。