Input Control with dynamic sql - problem in JasperServer 5

0

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

danielobs's picture
Joined: Mar 24 2010 - 1:52pm
Last seen: 5 years 10 months ago

0 Answers:

No answers yet
Feedback
randomness