using queries in parameters

[allstar]

Hi, 

I'm using jasper studio 5.6.1, and successfully created a report with a String parameter.

But now i'm trying to modify this parameter from String to List and populate this list with the result of a query to the database.

Is it possible ?

 

 

Thanks

[H Mendoza]

Yes.  You will need to create the parameter with a data class-type of Collection.  The query itself will need the following syntax: $X{IN, arg1, arg2}.  Testing in Studio wlil require that you provide list yourself.  For the Server, you will need to create input controls that include a query to pull back values from the database.  

[allstar]

Yes I created an input control in jasperserver, but how can i use an input control created in jasperserver in jasper studio ?

Thanks 

 

 

[hozawa]

Yes. Use P$!{} parameter instead of P${}. Check on Jaspersoft Studio user guide on instructions (Section 8.3.1 Using Parameters in a SQL Query)

http://community.jaspersoft.com/documentation/v561-v560/jaspersoft-studio-user-guide