Suppress Field Border 2

[yotwiggy]

In CR9 when setting the field border it does give you a suppress box and a place to put a calculation. I am trying to suppress the border based on a value in the record being displayed, but Crystal gives me an error at every turn.
Suppress if:
{fieldx} = "Y" --> tells me the outcome must be a number
{fieldx} = 1 --> tells me it expected a string.

HELP!
Thank you.

 

[bdreed35]

Try this inside your formula:

if {fieldx} = "Y" then
1
else
0

The return value needs to be a number 0 - 4. Each number identifies one of the border types.

0 - None
1 - Single
2 - Double
3 - Dashed
4 - Dotted


~Brian

 

[lbass]

The X+2 box isn't really a "suppress" box for borders, so your formula has to specify what you want it to do. If you have a single line around your field, and you want to, for example, eliminate the top line conditionally, create a formula like this:

if {fieldx} = "Y" then crNoLine else crSingleLine

The attributes available to you are shown under "Functions"->"Line Style" in the X+2 formula area.

-LB

 

[yotwiggy]

Thank you very much it works.