input control based on multi-select query

[nirum]

Hi,

I am trying to construct a report where I would like to

  a) populate an input control with a list from the database

 b) let the user select one or more of these and pass it to the report

The input control shows the list allright and lets me select but when executing the query it fails with

1 - Incompatible java.util.ArrayList value assigned to parameter first_name_last_name in the payRollTabularReport dataset.

java.lang.Exception: 1 - Incompatible java.util.ArrayList value assigned to parameter first_name_last_name in the payRollTabularReport dataset.

at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:394)

at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:311)

at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:80)

at java.lang.Thread.run(Thread.java:595)

Here is my query:

<parameter name="first_name_last_name" isForPrompting="true" class="java.lang.String"/>

select (concat(e.LAST_NAME,concat( ', ',e.FIRST_NAME))), e.payroll, w.pdate ,w.shift, w.code , w.rate,  w.on_time , w.off_time
 from worked w , emp e
where w.payroll = e.payroll and $X{IN, Employee, first_name_last_name};

Could you please provide pointers on what exactly I need to provide here. I tried changing the java.lang.String to java.util.ArrayList but then it would not show me my drop down filled with the first name, last name.

Thanks for your help.

 

Niru

[orentu]

Does somebody have an answer? I have ann exact similar problem

oren