File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes Jasper Report Dynamic query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Jasper Report Dynamic query" Watch "Jasper Report Dynamic query" New topic

Jasper Report Dynamic query

Bill attagasam

Joined: Jun 25, 2008
Posts: 5
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...
I agree. Here's the link:
subject: Jasper Report Dynamic query
It's not a secret anymore!