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...