Problem Using CASE in query

[NG]

I am trying to read a parameter value and getting error

The server has encountered an error. Please excuse the inconvenience.

  Here's the parameters I have

<parameter name="totalEmployees" class="java.lang.Number" isForPrompting="false">
        <defaultValueExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}.get("employees").size()]]></defaultValueExpression>
    </parameter>

<parameter name="a" class="java.util.List" isForPrompting="false">
        <defaultValueExpression><![CDATA[$P{totalEmployees} > 1000 ?$P{REPORT_PARAMETERS_MAP}.get("employees").subList(0,1000):$P{REPORT_PARAMETERS_MAP}.get("employees")]]></defaultValueExpression>
    </parameter>
    <parameter name="b" class="java.util.List" isForPrompting="false">
        <defaultValueExpression><![CDATA[$P{totalEmployees} > 2000 ?$P{REPORT_PARAMETERS_MAP}.get("employees").subList(1000,2000):$P{REPORT_PARAMETERS_MAP}.get("employees").subList(0,1000)]]></defaultValueExpression>
    </parameter>

I am trying to read the totalEmployees value and based on that I am trying to decide whether to use paramter a or b in the in statememnt:

Here's the where clause. (1=1 and 2=2  are just to show that there are other conditions)
    WHERE

1=1 and
    CASE WHEN  $p{totalEmployees}<1000 THEN $X{IN, name,a}
          ELSE $X{IN, name, b}
END AND
   2=2

Is there any syntax problem?

 

 

 

 

[grafro]

could you please post your whole report (jrxml)?

(inside a code block :) )