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:
VB Code:
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




Reply With Quote