wood burning stoves*
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
Author

Jasper Report Dynamic query

Bill attagasam
Greenhorn

Joined: Jun 25, 2008
Posts: 5
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...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Jasper Report Dynamic query