Static Parameter prompt

[jschill2628]

I have the following as my values in my static (Severity) parmeter prompt that I have created:

Fall- None
Fall - Minor
Fall - Moderate
Fall - Major
Fall - Death
MED- No Error capacity to cause error
MED- Error No Harm did not reach patient
MED- Error No Harm reached patient
MED- Error No Harm reach pt rq monitor/interv
MED- Error Harm Temporary reqd intervention
MED- Error Harm Temporary req hospitalization
MED- Error Harm contributed to Permanent harm
MED- Error Harm Req Intervention to sust life
MED- Error Death
Near Miss
No Harm
No Detectable Harm
Minimal - Temporary Harm
Minimal - Permanent Harm
Moderate - Temporary Harm
Moderate - Permanent Harm
Severe - Temporary Harm
Severe - Permanent Harm
Death


I have the following in my selection criteria:

and (
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 {IRSCLAIM.SPECIAL13} = "A" or
if {?Severity}= "MED- Error No Harm did not reach patient" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIM.SPECIAL13} = "B" or
if {?Severity}= "MED- Error No Harm reached patient" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIM.SPECIAL13} = "C" or
if {?Severity}= "MED- Error No Harm reach pt rq monitor/interv" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIM.SPECIAL13}= "D" or
if {?Severity}= "MED- Error Harm Temporary reqd intervention" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIM.SPECIAL13} = "E" or
if {?Severity}= "MED- Error Harm Temporary req hospitalization" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIM.SPECIAL13} = "F" or
if {?Severity}= "MED- Error Harm contributed to Permanent harm" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIM.SPECIAL13} = "G" or
if {?Severity}= "MED- Error Harm Req Intervention to sust life" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIM.SPECIAL13} = "H" or
if {?Severity}= "MED- Error Death" and {IRSCLAIM.COVERAGE}= "MED" then {IRSCLAIM.SPECIAL13} = "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"
)


My problem is when I select all of my "severities" only the falls come over onto the report. I want my user to be able to pick and choose which severities they want. Say for example if they want to only focus on the more sereve cases. What am I doing wrong.

I am using Crystal XI.

Thank you

 

[lbass]

Change the syntax to:

and (
(
{?Severity}= "Fall - None" and
{IRSCLAIM.COVERAGE}= "FALL" and
{IRSCLAIM.SPECIAL20} = "05"
) or
(
{?Severity}= "Fall - Minor" and
{IRSCLAIM.COVERAGE}= "FALL" and
{IRSCLAIM.SPECIAL20} = "10"
) or
(
{?Severity}= "Fall - Moderate" and
{IRSCLAIM.COVERAGE}= "FALL" and
{IRSCLAIM.SPECIAL20} = "15"
) or //etc.
)

Be sure to have the open and close parens around each section and around the entire block of these sections as shown.

-LB