issue with parameter

[jschill2628]

I am having an issue with my parameter. I have never encountered this before. I have linked a code table to my main table, as I normally would, this works for a cross tab I have built into the crystal report (Crystal XI). The formula I have in my report is

{ReviewerSeverity}:
{ReviewerSeverity.CODE} + "-" + {ReviewerSeverity.CODE_DESC}

Now when I try to create a prompt {?Severity}, I choose dynamic prompt, then I choose new. For the value I choose {ReviewerSeverity.CODE}, and for the description I choose {ReviewerSeverity.CODE_DESC}.

Then I go the Selection Criteria and say {IRSCLAIMSA1.SA153} = {?Severity}

This is how I would normally do a simple prompt like this. The problem is that instead of just getting the ten values I need (minor, major, etc….) I am getting every code and code description in the whole code table.

What am I doing wrong?

Thanks in advance!

 

[lbass]

What is your entire record selection formula (report->selection formula->record? I'm wondering if you have an "or" statement in there that is being misinterpreted.

-LB

 

[jschill2628]

good guess, but nope.....

LowerCase ({USRMAST.EMAIL2}) = LowerCase ({@UserName})
and {IRSCLAIM.create_DT} = {?Report Date}
and {IRSCLAIM.LOCATION} = {?Location}
and {IRSCLAIM.SPECIAL4} = {?Event Subtype}
and {IRSCLAIMSA1.SA153} = {?Severity}
and {IRSCLAIM.COVERAGE} = "ADR"
and {Subtype.CODE_TYPE} = "11"
and {IRSCLAIMSA1.SA151} = "3"
and {IRSCLAIMSA1.SA152} = "3"
and {PrimaryInjury.CODE_TYPE} = "26"
and {ReviewerSeverity.CODE_TYPE} = "100084"
and {IRSCODE_LineOfBusiness_A.CODE_TYPE} = "45"
and {IRSCODE_LineOfBusiness_B.CODE_TYPE} = "46"
and {IRSCODE_LineOfBusiness_C.CODE_TYPE} = "18"
and {IRSCODE_Outcome.CODE_TYPE} = "100090

 

[lbass]

Is the parameter set up to allow multiple values and is it a string parameter? If so, add a formula to your report:

join({?Severity},",")

...and then add these fields to a detail_b section (suppress your detail_a section):

{IRSCLAIMSA1.SA153} {ReviewerSeverity.CODE}{ReviewerSeverity.CODE_DESC}

...and run the report with your current selection formula. Then report back with the results.

-LB

 

[jschill2628]

I got the same reults, as before.

I was going to put in the code and code description in by hand instead of pulling from the field, but I didn't want to do this incase down the road we change a description, or add more code I would 't have to change 70 reports.

 

[lbass]

Please show the results when you did what I requested.

-LB

 

[jschill2628]

prompt:
00- Near Miss
01- Midnight
02- Outpatient
03- Family Member or Caregiver
04- Beth O'Brien
05- Contractor
06- Concussion
07- 07:00
08- Supplemental Ben. (FL only)/ Supplemental Earrings.....
09- Death


Detailed section B:
SA153 Code Code DESC
01 01 No Harm
02 02 No Detectable Harm
02 02 No Detectable Harm
02 02 No Detectable Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
02 02 No Detectable Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
02 02 No Detectable Harm
02 02 No Detectable Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
01 01 No Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
02 02 No Detectable Harm
05 05 Moderate - Temporary Harm
05 05 Moderate - Temporary Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
05 05 Moderate - Temporary Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
03 03 Minimal - Temporary Harm
01 01 No Harm
01 01 No Harm
03 03 Minimal - Temporary Harm
05 05 Moderate - Temporary Harm
03 03 Minimal - Temporary Harm
02 02 No Detectable Harm

 

[lbass]

It looks like maybe your codes table isn't linked to your other table. Link {ReviewerSeverity.CODE} to {IRSCLAIMSA1.SA153} in the database expert.

-LB