Parameter from cascading input control not being passed to SQL query

[jkeri]

Jasper version 6.3

 

I have two parameters:   Single select for COUNTRY. depending on which COUNTRY, my cascading input control displays a list of STATES. User can select one or multi STATES.

In the report query i have a WHERE CONDITION     $X{IN,table_field,STATES}

STATES is definied as a java.util.ArrayList.

 

PROBLEM.   The SQL WHERE condition doesnot work. It looks like STATES contains null even though I selected multi from the dropdown.

 

 

[mlopez_1]

Make sure that you have both, parameter and input control with exactly the same ID for 'STATES'.

Mariano

[jkeri]

Mlopez.

 

Thank you for the time. You were absiolulty correct in your solution. There was a small speeling difference that was hard to spot.