Choosing one of two fields in database based on data in one of them

Piotr Pogoń

• 2021年12月29日 18:11

Hi,

I have a situation to solve and it is like that:

I use connection to an excel database, Lets say for example database has 2 columns A and B.

Now in column A I have default data - product name. And in that record on column B i have a "yes" or "no" tag. So, in the field I have to print data from column A if the column B says "yes" and if column B says "no" I have to - instead of data from column A - print "Changed" - just this word.

Is there a way to do something like that? If so, how should I go about it?

Thanks for the response!

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2021年12月29日 20:30

  For you Column A field configure a Suppression routine from the Transforms tab that Suppresses showing the column A data is Column B equals No.

  Then add a second sub string with Embedded Data Changed and use the Transforms>Suppression to suppress this is if Column B Equals Yes.

  So you should get something like this

  

   

  Note: I included the top two fields just so you could see the original data and these are not needed to make the process work. A print preview of the labels is below.

  

  0
• 

  Piotr Pogoń

  ★ BarTender Hero ★

  • 2021年12月31日 14:26

  Pete, thank you very much, thats exactly what I needed :)

  0

請登入寫評論。