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

0

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!

2 评论

0
Avatar
Peter Thane
评论操作 固定链接

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
Avatar
Piotr Pogoń
评论操作 固定链接

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

请先登录再写评论。