Crystal Reports make text box visible true false

Question

I need to make a text box visible true, false based on the value of a Boolean type column in the data set. How can I do that?

Solution 1

-Right click on field and select 'Format Object'.

-On the 'Common' tab select the formula editor button to the right of the 'Suppress' label.Click the suppress check box and then click the formula editor button.

-For true to be visible set formula to '{Field} = true'

-For true to be hidden set formula to '{Field}=false'

Solution 2

Thanks Justin & Thanushka!

1. Right click on field and select 'Format Object'.

2. On the 'Common' tab select the formula editor button to the right of the 'Suppress' label.Click the suppress check box and then click the formula editor button.

3. To be visible set formula to: {Field} = 'true'

4. To be hidden set formula to: {Field}= 'false'