A boolean is required 2

[pineisland99]

Attempting ti build the below formula but am receiving the above error on saving it:

if {TRACKING_FILE.f453#processor_name} or
{TRACKING_FILE.f321#closer_name} = "Naheed Gulamali" then
if UCase({TRACKING_FILE.fu36#loan_queue}) = "Processing" then
1
else
0


What am I doing wrong?

 

[dgillz]

First, what version of crystal. You should never post without this information.

Second, a boolean is a formula that eveluates to true or false. This is required in crystal for conditional formatting formulas, as well as record or group selection formulas.

So how are you creating this formula? Step by step?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[pineisland99]

Crystal Version 9.2

How am I creating this formula - I had the formula as below when I was using groups, but now management has changed the request so need some more logic...

NumberVar ProcCount;
if UCase({TRACKING_FILE.fu36#loan_queue}) = "Processing" then
1
else
0

 

[dgillz]

You posted the formula itself, not how you created it.

For example, clicking on report->edit selection formula->group is one way to create a formula, and in this case, the WRONG way for your formula, as it is not a boolean formula.

So once again, how did you create your formula? Click by click, key by key, what did you do to create it?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lbass]

Try the following for a formula in the field explorer:

if
(
{TRACKING_FILE.f453#processor_name} = "Naheed Gulamali" or
{TRACKING_FILE.f321#closer_name} = "Naheed Gulamali"
) and
UCase({TRACKING_FILE.fu36#loan_queue}) = "PROCESSING" then
1
else
0

Note that "processing" needs to be in upper case to get a value check.

-LB

 

[pineisland99]

I was creating the report under the field explorer. I did try the solution by lbass and it appears to work well.

Thank you all for your help.