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"

What am I doing wrong?

thanks,
Blake

[baja_yu]

You might want to try the Reporting Forum http://www.vbforums.com/forumdisplay.php?f=33

[brucevde]

The Record Selection Formula is used to further discard unwanted records returned from the datasource. Create a new formula, add your code and then display the formula result in your report.