Conditional report title formula

[TerriO]

Having trouble getting this report title to only print the Campaign name when the salesperson is null, it still puts in the Salesperson:"

if not isnull({?@SALESPERSON}) then ("Salesperson: "+{?@SALESPERSON}) + "Campaign: " + {@Report Title Line 3 Formula}
else "Campaign: " +{@Report Title Line 3 Formula}

Current result if Salesperson is null is :

Salesperson: Campaign: Purchase Follow Up

I don't want Salesperson Printed unless a value for the salesperson Parameter is entered.


Terri

 

[alvintse]

An empty string is not equal to NULL. Try
if not isnull({?@SALESPERSON}) and len ({?@SALESPERSON}) > 0 then .....

 

[synapsevampire]

Or:

if isnull({?@SALESPERSON}) or trim({?@SALESPERSON}) = "" then
"Campaign: " +{@Report Title Line 3 Formula}
else
("Salesperson: "+{?@SALESPERSON}) + "Campaign: " + {@Report Title Line 3 Formula}

-k