Simple Selection Question

[bamitts]

I don't use Crystal very often, so please forgive my obvious lack of knowledge...and thanks in advance for any help!

Using Crystal 9, SQL Database

I am attempting to write a selection formula to filter Equipment. I want to ask the parameter "(A)ctive (I)nactive or blank for all?" . I've used the following formula:

(if {?IncludeInactive} = 'A' then {EMEM.Status}= 'A'else
if {?IncludeInactive} = 'I'then {EMEM.Status}= 'I'else
1=1)

Not working, I always get all?! Any help?

 

[dgillz]

if {?IncludeInactive} = 'A' then {EMEM.Status}= 'A' else
if {?IncludeInactive} = 'I'then {EMEM.Status}= 'I' else true

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

http://www.gainfocus.biz

 

[lbass]

I would add a parameter option of "Both" and then use a record selection formula like:

if {?Include} <> "Both" then
{EMEM.Status}= {?Include} else
if {?Include} = "Both" then
true

-LB