Use of SQL Query as Input control

[rschaphalkar]

Hi,

I am using the single-select query as an input datatype on one of the reports. This input datatype is mapped in iReport using the parameter type java.lang.string. When I run the report, the drop down list is empty. I dont know why the query is not returning any values. Please let me know if anyone has worked with single-select query as input data type.

Thanks

[prasad_psl]

Hi,

SQL Input Control is need the connection with database to fill the prompt.

So global input control will not have active connection with the database.

So one should use the SQL prompt with the existing report,User should create that locally when the wizzard ask to create input control.

I think it will work.

Thanks

Prasad