Conditionally format border 1

[Bennie47250]

Using Crystal 7.0

I have a number field that I want to conditionally have a bottom border. In the X2 field I have entered the condition {MyTable.MyField} = "D" and Crystal tells me "The Formula result must be a number" I have used the same condition on a string field without any issues. How can I work around this?

Thanks

 

[lbass]

You need a formula like this:

if {MyTable.MyField} = "D" then
crSingleLine else //code = 1
crNoLine //code = 0

You can use either the number or the text in XI. Not sure what CR 7 allows.

-LB

 

[Bennie47250]

Thanks, the code ended up being
if {MyTable.MyField} = "D"
then 1
else 0