Crystal Reports Selection Formula If No Match Then

1
votes

I currently have a Crystal Report with a selection formula that looks like this

{dbo.CustomerName}={?CustomerName}
 AND
{dbo.Opportunity}={?Opportunity}

An issue that I'm finding is that sometimes there isn't a matching customer name, but the report still needs ran on the subsequent selection formula. Is there a way to create an IF THEN statement that says something like:

IF IsNull({dbo.CustomerName}={?CustomerName})
 THEN
{dbo.Opportunity}={?Opportunity}
 ELSE
({dbo.CustomerName}={?CustomerName} AND {dbo.Opportunity}={?Opportunity})

Obviously the IsNull operator requires a field and not a statement, but I'm not sure how to accomplish what I'm trying to accomplish

1
crystal-reports

1 Answers

0
votes

The following should work:

(IsNull({dbo.CustomerName}) AND {dbo.Opportunity}={?Opportunity})
 OR
({dbo.CustomerName}={?CustomerName} AND {dbo.Opportunity}={?Opportunity})