Crystal Reports Formula problem

[blakemckenna]

I am trying to use crystal reports 8.5. I have created a formula that is not working. It's very simple yet, I still can't get it to work. Below is what the formula looks like:

If IsNull({tblClientAddr.addAddr2}) Then
   {tblClientAddr.addAddr1}
Else
   Trim({tblClientAddr.addAddr1}) & ", " & Trim({tblClientAddr.addAddr2})

I keep getting the error message:

"The result of the selection formula must be a boolean"

I also stuck the End If statement in at the end but it still gives me that message. What am I doing wrong?

thanks,
Blake

[_visual_basic_]

i think there is a special forum for this... anyway can you post the line of code that it is high lighting?

[blakemckenna]

It's the very beginning of the statement....the cursor sets right in front of the IF.

[blakemckenna]

Ok,

Now if I insert the End If at the end of the If statement....I get the following error msg:

If IsNull({tblClientAddr.addAddr2}) Then
   {tblClientAddr.addAddr1}
Else
   Trim({tblClientAddr.addAddr1}) & ", " & Trim({tblClientAddr.addAddr2})
End If

"The remaining text does not appear to be part of the formula" and the cursor sets at the end of the else branch.

Hope that helps!

[_visual_basic_]

is it just me or dont i see anything in this code

[RobDog888]

I think it needs to be like this.

If IsNull({tblClientAddr.addAddr2}) = True Then
   {tblClientAddr.addAddr1}
Else
   Trim({tblClientAddr.addAddr1}) & ", " & Trim({tblClientAddr.addAddr2})

Edit: Its been a while since I used CR, but I also think that maybe it needs to actually return a True or False.

[blakemckenna]

That didn't work Rob....still gives me the same error msg...

[RobDog888]

I think I know what your trying to do. You need two textbox controls. One
bound with just field1 and the other bound with field1 and 2. Then in the
formatting properties of the two textboxes, add this formula to each. It will
test for field 2 to be null. If it is it sets the visibility to true or false.
Toggeling each textbox.

If IsNull({tblClientAddr.addAddr2}) = True Then
   True
Else
   False

Then in the other textbox, use this.

If IsNull({tblClientAddr.addAddr2}) = True Then
   False
Else
   True

[blakemckenna]

Rob,

Actually, I have had this formula working in the past and for some reason it's not working now. Anyway, I will try a few more things....

Thanks

[dglienna]

Take out the if/else/end, and try the first statement. It doesn't look like it is doing anything. Whatever you are trying to do doesn't look right. The else clause just concatenates it.

[blakemckenna]

I tried using this:

{tblClientAddr.addAddr1} & ", " & {tblClientAddr.addAddr2}

and it still gave me the msg:

"The result of the selection formula must be a boolean"

[RobDog888]

David, he is trying to show only the addres that is populated in the db. If the
address has only one field the show just that. If the address has two fields
then show both.

[RobDog888]

Also, where is this formula under, Suppress? If so Suppress need to return a
True or a False so it knows how to show the control.

[blakemckenna]

Rob,

the formula is not being suppressed!

[RobDog888]

Hmm..., how about placing the code in a Formula Field. Then bind that
formula field to your address textbox?