Choosing one of two fields in database based on data in one of them
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!
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
Pete, thank you very much, thats exactly what I needed :)0