• Post Reply Bookmark Topic Watch Topic
  • New Topic

Jasper Report Dynamic query

 
Bill attagasam
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI,
I modify the query to be like this
SELECT * FROM TABLE where $P{whereClauseAsParameter}

from ireport, but I didn't run the report in iREport


I invoked the report from web passing multiple parameters to servlet and I construct the where clause from servlet as "whereClauseAsParameter" and pass it to the report and I got error msg:
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

can someone please help me how to write dynamic query in jasper report...
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!