[How to write SQL with dynamic parameter!!!!]

:( Hi all!

 

I have some dynamic reports. I have a question like "

(($F{NAME})==null?"SELECT * FROM CITIES;":"SELECT * FROM CITIES WHERE NAME ='London';

".... later. I want to make a report with one para. If I put a para by condition in the query. That is Ok. But I do not want to put a para into the query. it is error . :( . I used the same query in the forum. But it is error.

Please let me know how to write a dynamic query!!! :( .

Thanks advance!!!

Best regards!

:cheer:

Note!

Sorry! my Enghlish is not good!

[Put parameters into compiere !!]

Hi all!

 

I have been developing a software

and using tool Ireport of Jasper for making some reports. So I have difficuties to put parameters from a class to Ireport. Please tell me how to put them!! If anyone has solutions,Please send me some related codes.

Thanks! :)

[Put parameters into compiere !!]

Hi all!

 

I have been developing a software

and using tool Ireport of Jasper for making some reports. So I have difficuties to put parameters from a class to Ireport. Please tell me how to put them!! If anyone has solutions,Please send me some related codes.

Thanks! :)