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
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
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
