Input Control with dynamic sql - problem in JasperServer 5

[danielobs]

Hi,

I have problem with Multi-select List of Values with dynamic sql:  

SQL is:
SELECT distinct a.KONTRAHENT, k.NAZWA, k.NAZWA2, k.ULICA, k.MIASTO, k.KODP,  k.NIP from nrlog as a left join kontra as k on a.kontrahent=k.kontrahent
where a.kontrahent>0 and a.data_log>=$P!{DATE_FROM} and a.data_log<=$P!{DATE_TO}

Parameters are: $P!{DATE_FROM} and $P!{DATE_TO}
These Imput Control are located above the dynamic list.

Unfortunately, the SQL does not generate me a list.  

Static SQL working properly:
SELECT distinct a.KONTRAHENT, k.NAZWA, k.NAZWA2, k.ULICA, k.MIASTO, k.KODP,  k.NIP from nrlog as a left join kontra as k on a.kontrahent=k.kontrahent
where a.kontrahent>0  and a.data_log>='20130101' and a.data_log<='20130116'

I use MySQL database and  JasperServer 5.

 

How to display content in JasperServer 5 SQL query for the  Multi-select List of Values

Best regards,

Daniel