Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • 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...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic