Jasper & Dynamic Query

[logudotcom]

I have encountered a problem in creating dynamic reports using Jasper Reports. The problem is that,

 

"The query has to be passed to the .jrxml file dynamically." from the java webapp.

 

I pass the query using parameter. Parameter name is "querystring". The type is "String". When I pass the value from the java code, the value(select * from tbl1) is preceded and ended with a single quote(value would be 'select * from tbl1' ). So the database would throw an error saying, "Parse error at character 1".

 

If you have any solutions, you are welcome to share it with me

 

Thanks

[tarelr]

in your jrxml file,

how do you call your parameter queryString?

 

Be sure you call le the parameter with the $!P{} synthaxe.

[amila325]

i have the same prob i need to send a query to jasper jrxml file can you please give me a small example both jrxml file and java file

Thank you in advance :) :)