Thursday, 10 August 2006
Crystal Reports: join / concatenate null strings
I was getting blank fields in my crystal report if one of the values in the formula was null.
Thanks to this post
i know better than to trust Crystal's crummy concatenation rules. Here is what
had to say:
A string concatenated with null always gives null.
Thursday, 10 August 2006 17:31:20 (GMT Daylight Time, UTC+01:00) .Net General | .Net Windows Forms | Asp.Net
You have to check if the first name is null with
if not IsNull(firstname) then
lastname + " " + firstname