Jump to content
Changes to the Jaspersoft community edition download ×

Jasper & Dynamic Query


logudotcom

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...