I have post a relative common question in iReport quary design about 2 weeks ago, but havn't got any response.
Here is the problem. A multi-select (Or multi-dropdown) parameter is required in our report, the parameter then passed to a stored procedure written in MS/SQL server. In order to use the multi-select parameter, java.util.List or java.util.Collection is required, but the stored procedure is expecting a string with carma delimit in the string. Such as "'Office1', 'Office 2',...".
To summarize, how to convert java.util.List as parameter to a String. There is function $X(} to do this kind of casting, but that is only good in SQL.
I'd appreciate if someon can give any idea, or any response even if you have run into same issue and need to be solved.
Thanks,
YZ1