if statements in reports

[TiCi]

hello again..

thanks for your reply mm0000 and MikeLewis.
but i have one more question. can i make an if statements in reports? if in a form we refer a value in textbox1 with thisform.textbox1.value how do we refer the value in a field control, or perhaps we used something else? in example: the field is in logic. and if true the value will be notyet, or no. and if false the value is yes. can a report do that?

thanks and regards..

 

[mm0000]

You can use the iif() function to achieve what you want.

Eg: iif(fieldvalue = .t.,'YES','NO')

Replace fieldvalue with the actual logical field name.

HTH