Compare Crystal report text

Asked

Viewed 236 times

1

Good afternoon. I would like to know how to assemble a formula in the Crystal report so that you see, if in the text the word "QTDA", if it exists it signals the whole cell with the color red, if it does not do anything...

  • I am without the CR here but has a Function that does it ,POS or INSTR I believe.

1 answer

1


1:Right click on the column and go to "Format Object"

inserir a descrição da imagem aqui

2:Frame Tab Frame 3:Color section, where has the Background option, click the button next Formula

inserir a descrição da imagem aqui

4:Use the following formula below:

If instr({@Campo}, "QTDA") <> 0
   Then crRed 

Browser other questions tagged

You are not signed in. Login or sign up in order to post.