create a dynamic query

[razaalirizvi]

i can pass parameter to the query written in  my report.jrxml  file

but what if  i want to create that query in java and send that complete query in report.jrxml??

how to do that.

 

any help will be appreciated.

 

thanks.

[Teodor Danciu]

Hi,

 

By looking at the /demo/samples/query sample provided with JR, where you can see the $P!{} syntax being used inside the query.

Actually, the whole query could be passed in like that.

 

I hope this helps.
Teodor

 

[razaalirizvi]

Basically i want to pass the whole query in that.

but no iformation is provided for that.

parametes can be accessed using $P{variable_name}.

 

but cant pass whole query in that.

 

 

[lucianc]

You can pass the whole query with $P!{queryText}.  See http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/tutorial.html?group_id=252#Parameters for a short explanation on this topic.

Regards,

Lucian