Geek Answers Handbook

Crystal Reports makes the text field visible true false

I need to make the text box visible true, false based on the value of the Boolean type column in the dataset. How can i do this?

+4
source share
3 answers

-Then click on the field and select "Object Format".

- On the General tab, select the formula editor button to the right of the Suppress label. Clear the suppression check box, and then click the formula editor button.

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

-For truth, to hide the setup formula to '{Field} = false'

+7
source

Thanks to Justin and Tanushka!

  • Right-click on the field and select "Object Format".

  • On the General tab, select the formula editor button to the right of the Suppress label. Click the "Disable" checkbox, and then click the formula editor button.

  • To be visible, set the formula: {Field} = 'true'

  • To hide the formula of the formula: {Field}= 'false'

+1
source

You can also consider the keyword CurrentFieldValue. Using CurrentFieldValue instead of the actual field name, it is easy to copy formatting between similar fields using Format Painter.

In your situation, the suppression formula will be

 CurrentFieldValue=True

A clean trick to turn a boolean into a Yes / No value is to use the Display String field; It is also on the General tab. Enter the following formula:

 IIf(CurrentFieldValue=True, 'Yes', 'No')
0
source

More articles:


All Articles