getting data from a parameter

[jschill2628]

I have a severity prompt (parameter) in my report. The prompt is a static prompt that simply list the values of severity none, minor, major, etc. In my selection criteria I have the following…….

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


Which is great, except for when I only want to choose severity’s like Major and Death, the report shows nothing, when there was data there before.

What am I doing wrong?

Thanks in advance.

 

[IanWaterman]

How is Major and Death entered into parameter.

I assume its a multi value paramter and "Major" and "Death" are entered separately.

If you eneter it as "Major and Death" it will not work as you have expecetd in select expert.

Ian

 

[IanWaterman]

Also why have you used or instead of else?

 

[NiceArms]

I may have the fields the wrong way round but when using IF logic I tend to write it as follows:

if {?Severity} = "none" then
	 {IRSCLAIM.COVERAGE}= "FALL" and {IRSCLAIM.SPECIAL20} = "05"
[b]ELSE [/b]
	if {?Severity} = "Minor" then
		{IRSCLAIM.COVERAGE}= "FALL" and {IRSCLAIM.SPECIAL20} = "10"
	else
		if.....etc etc

I am a little confused by how you have written your code but if you follow the above structure you should get the result you need.

I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!

 

[jschill2628]

When I do it with the else instead of the or, and I select in my prompt to choose all the values (see below)

None
Minor
Moderate
Major
Death

it only brings across the first value of "None".

I want my user to be able to pick all, or some of the values.