prompt selection

[jschill2628]

Hi I have a Severity Prompt {?Severity}. In the prompt I simple list out the values (Fall- None, Fall- Minor, etc.) My problem is all of a sudden when I try to select one severity such as "Fall- None" from the prompt I get zero results, but when I select all the severities I get numbers. So the prompt will let pick all severities but not select one or a few select severities.

THANK YOU very much!!!!

I am using Crystal XI

Below is what I have put in the Selection Criteria:


(if {?Severity} = "ALL" then not isnull ({IRSCLAIM.CLAIM}) else
if {?Severity} <> "ALL" then

(if {?Severity}= "Fall - None" and {IRSCLAIM.COVERAGE}= "FALL" then {IRSCLAIM.SPECIAL20} = "05" or
if {?Severity}= "Fall - Minor" and {IRSCLAIM.COVERAGE}= "FALL" then {IRSCLAIM.SPECIAL20} = "10" or
if {?Severity}= "Fall - Moderate" and {IRSCLAIM.COVERAGE}= "FALL" then {IRSCLAIM.SPECIAL20} = "15" or
if {?Severity}= "Fall - Major" and {IRSCLAIM.COVERAGE}= "FALL" then {IRSCLAIM.SPECIAL20} = "20" or
if {?Severity}= "Fall - Death" and {IRSCLAIM.COVERAGE}= "FALL" then {IRSCLAIM.SPECIAL20} = "25"
) or

(if {?Severity}= "MED- No Error capacity to cause error" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIMSA1.SA150} = "A" or
if {?Severity}= "MED- Error No Harm did not reach patient" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIMSA1.SA150} = "B" or
if {?Severity}= "MED- Error No Harm reached patient" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIMSA1.SA150} = "C" or
if {?Severity}= "MED- Error No Harm reach pt rq monitor/interv" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIMSA1.SA150}= "D" or
if {?Severity}= "MED- Error Harm Temporary reqd intervention" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIMSA1.SA150} = "E" or
if {?Severity}= "MED- Error Harm Temporary req hospitalization" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIMSA1.SA150} = "F" or
if {?Severity}= "MED- Error Harm contributed to Permanent harm" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIMSA1.SA150} = "G" or
if {?Severity}= "MED- Error Harm Req Intervention to sust life" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIMSA1.SA150} = "H" or
if {?Severity}= "MED- Error Death" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIMSA1.SA150} = "I"
) or

(if {?Severity}= "Near Miss" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "00" or
if {?Severity}= "No Harm" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "01" or
if {?Severity}= "No Detectable Harm" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "02" or
if {?Severity}= "Minimal - Temporary Harm" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "03" or
if {?Severity}= "Minimal - Permanent Harm" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "04"or
if {?Severity}= "Moderate - Temporary Harm" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "05"or
if {?Severity}= "Moderate - Permanent Harm" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "06" or
if {?Severity}= "Severe - Temporary Harm" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "07" or
if {?Severity}= "Severe - Permanent Harm" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "08" or
if {?Severity}= "Death" and {IRSCLAIM.COVERAGE} in ["ADR", "BEH", "EQUI", "IVBP", "LAB", "MAT", "PCE", "SURG"] then {IRSCLAIMSA1.SA153} = "09"
))



I hope you can help, thank you!

 

[hilfy]

I would take out this line as it is unnecessary:

if {?Severity} <> "ALL" then

Also, try using "else" instead of "or" in your if statements.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.