Jasperserver Reports dynamic prompt

[prasad_psl]

Hi,

 

I need to create a dynamic prompt which will have the values come from SQL query.User will select any of the value in the prompt.Based on that value Report will execute.

I can handle the execution of the report.But i need help on how can i fill the prompt by SQL query.

 

please suggest the way.

 

Thanks and Regards,

Prasad

 

[lucianc]

Is this about JasperServer?  If so, see the sample reports shipped with JS.

Regards,

Lucian

[prasad_psl]

Hi,

Yes it is jasper server.

I find the solution.If the SQL prompt is with the report that is it is not a global variable.Its working fine.

Because the SQl query will use the same connection as the report does .Prompt should be created locally withe report on which this prompt is being used..

 

Thanks

Prasad

[bchandrasekarsamiyathal]

Prasad,

I have the same requirement too. Please explain how to achieve it?

I have created a parameter with java.util.List datatype for Dropdown. But i dont know how to proceed?

 

Thanks,

Bharath