Hi, can anyone help me with a basic formual to rename blank field strings/values in crystal 11.

I have a support report where one of the support team names is blank/empty. I need to replace the blank with the word EmailListener. I have tried the below and now all of the data from the report dissapears:


if {Incident.OwnerTeam}=""
then

{Incident.OwnerTeam}="EmailListener"

else

{Incident.OwnerTeam}="{Incident.Owner}"

Can anyone advise?

Many thanks
James

Thanks for the reply.

I had tried this but I get an error: "The result of a selection formula must be a boolean".

Any suggestions?

Thanks
again,
James

Makes perfect sense now, that is what I was doing wrong.

Thanks!
James