concatenating strings in crystal reports 1

[DavidSherring]

I am trying to concatenate two strings, with a comma and space in the middle. If one of these fields is a blank or null, then the whole string doesn't print. I have never come across this before. Anyone help, sorry it is such a pathetic question.

{VENUES.VENUE_NAME} +", "+ {VENUES.LOCATION}

Thanks

David

 

[lbass]

Set up the formula like this:


(
if isnull({VENUES.VENUE_NAME}) then
"" else
{VENUES.VENUE_NAME}
)+
(
if not isnull({VENUES.VENUE_NAME}) and
not isnull({VENUES.LOCATION}) then
", "
) +
(
if isnull({VENUES.LOCATION}) then
"" else
{VENUES.LOCATION}
)

-LB