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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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...
 
wood burning stoves
 
subject: Jasper Report Dynamic query
 
Similar Threads
Jasper with StoredProcedures
How to dynamically execute query under condition in Jasper Report (iReport)?
Jasper Reports / iReports Dynamic Query
reporting tools...
Mysql dynamic query,java and japer report