Using Formula in SQL Select

[MikeCopeland]

Using CR 8.5...

I need to use the result of a formula I've developed as a component of my Select statement - the formula is named isOkay and returns values of 1-4. My current "where" clause is:
WHERE Referral."ClientLastName" <> 'TEST'
to which I want to add
"AND @isOkay = 4".
I get runtime errors when I try this, so I'm sure I have the syntax wrong... I can't find any reference in the Help for such a technique. Any thoughts? TIA

 

[lbass]

What is the content of your formula {@isOkay}?

-LB

 

[MikeCopeland]

// @isOpen
if (isNull({Referral.Closed})) then 4
else
if (isNull({ReferralHistory.CloseReasonKey})) then 2
else
if ({ReferralHistory.CloseReasonKey} = 0) then 3
else 4

 

[lbass]

Go to report->edit selection formula->record and enter:

{Referral.ClientLastName} <> 'TEST' and
(
isnull({Referral.Closed}) or
(
not isnull({ReferralHistory.CloseReasonKey}) and{ReferralHistory.CloseReasonKey} <> 0
)
)

-LB