Multiselect question

[daningaddr]

We are on 4.7.0 ce

 

In the report, we need to select multple client ids, and pass to stored procedure. I defined "publisher_clients" as a collection for multiselect input control, and another parameter "client_ids" to get string from "publisher_clients" from . client_ids is passed to stored procedure in the .

 

But it does not work, "client_ids" cannot get things selected, it is either empty or just one item.

 

Anything I did wrong?

 

jrxml file is attached

 

 

 

Thanks,

 

Daning

[daningaddr]

Here is the jrxml

 

$P{publisher_clients}.toString()

CALL contextlinks3.contextlinks_pub_report_2($P{starting_date},$P{ending_date},$P{client_ids},0,1,1,0,1,0,0,1);

[cjasper]

I Don't know the exact solution. I guess you have to cast the  publisher_clients to varchar in your input control query.

and

 name="publisher_clients" class="java.util.Collection" nestedType="java.lang.String">.

[daningaddr]

Thanks a lot. amazing! that worked. but looks something is wrong to deal with integer collection in jasperserver