If ... then .. else 1

[Kendel]

Hi All,

I'm working on my very first report and I have little problem with the If statement. I'm using version 10 of crystal report. When I try do an IF statement, I got this err msg: "The result of the selection formula must be boolean"
I am in Formula Workshop/Selection Fomulas/Group Selection.
And here is my IF:

If GroupName({Status}) = "A" Then "Active" else
If GroupName({Status}) = "S" Then "Suspended" else
"N/A"

Can someone please help me out? Thanks.

 

[Kendel]

I'm grouping my report by status. If the status is "A" then display it as "Active" and so on ....

 

[Turkbear]

Hi,
Where are you using this formula?

To group on it, create a formula called , for instance, Grp1 and use your code there, then use the Insert Group option and choose the formula and not the Status field..






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

 

[Kendel]

Thanks for your help. Where is the new formula window? I can't find it. The only button I saw is X+1 Formula Workshop.

 

[Kendel]

Nevermind. I found it. Thanks.

 

[Turkbear]

In the 'Field Explorer' window..Right-Click on Formula choose 'New'...

Not in the Group settings area...





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