Simple If Then Statement

[WPCMS]

I use CR IX and I am a new user. I have a simple formula (at least I think it is) to add to my report.

//crystal syntax
WhilePrintingRecords;
If {Asgnmnt.CSHold} = "True"
then "HOLD"
Else ""


When I view the report it is "" all the way. {Asgnmnt.CSHold} is a check box, so I am assuming this is a Boolean T/F.

WPCMS

 

[Madawc]

Try displaying {Asgnmnt.CSHold}. IT should show True or False, which is what happens with boolian formula fields.

Also try using ISNULL in your test: unfilled fields can often be nulls and hitting a null will always stop a formula.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[WPCMS]

//Crystal Syntax
WhilePrintingRecords;

If (not isnull({Asgnmnt.CSHold}) = "True"
then "HOLD"
Else ""

There is an error, I am pretty sure I am missing something.

 

[lbass]

It probably should be expressed without the quotes. You also don't need "whileprintingrecords".

If {Asgnmnt.CSHold} = true
then "HOLD"
Else ""

-LB

 

[dgillz]

Try this:

If isnull({Asgnmnt.CSHold}) then "HOLD" else
if {Asgnmnt.CSHold} then "HOLD" else ""

WhilePrintingRecords should not be needed.

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

 

[WPCMS]

It still didn't work.

 

[lbass]

Put the field {Asgnmnt.CSHold} in the detail section and then report back with what it displays--or right click on it and choose browse data and then let us know.

-LB

 

[Madawc]

Put the tests into several separate formula fields. Put them onto a test detail line under the main detail line. Find what result it's actually getting.

You've been given formulas that should work, so it's highly likely the data is not what you think it is.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[WPCMS]

Browsing the data it says T,F or blank. I entered the formula exactly

If isnull({Asgnmnt.CSHold})
then "HOLD"
else if {Asgnmnt.CSHold}
then "HOLD"
else ""

and I get a formula error saying "HOLD" a statment is expected here.When I switch it to Crystal Syntax it says {Asgnmnt.CSHOLD} Boolean statement expected here.this is Driving me nuts.
Maybe this is not so simple after all! What am I not seeing?

 

[Turkbear]

Hi,
Blanks are not the same, always, as NULLs so test for both:

If (
 isnull({Asgnmnt.CSHold})
 OR 
 Trim(({Asgnmnt.CSHold}) =""
 OR
 {Asgnmnt.CSHold} = "F" 
)
then 
"" 
Else
"HOLD"

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[NavyFederalDetta]

Your "else if" doesn't have a condition.

You've stated:
"if {Asgnmnt.CSHold} ISNULL then"

but when you say "else if" you don't tell it "if what". In other words, is it if CSHold is True? if CSHold is False, etc.

Try giving your "else if" a condition.
If isnull({Asgnmnt.CSHold})
then "HOLD"
else if {Asgnmnt.CSHold} = "True"
then "HOLD"
else ""

 

[dgillz]

Navy,

The field is not a true/false (also known as boolean) field. It is a char field with values of "T", "F" or null.

Use Turkbear's formula.

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

 

[WPCMS]

None of the above worked so I fiddled with it and researched and it worked with this formula.

If {Asgnmnt.CSHold}=""
then ""
else if {Asgnmnt.CSHold} = "T"
then "HOLD"
else ""

WPCMS