java - Passing an entire sql query as a parameter in jasper reports -

i want pass entire sql query parameter jasper report. tried using $p{query}, gave me mysql syntax error exception. , want passed during run time. know how it?

example code:

try {         map<string, object> map = new hashmap<>();         connection conn = databaseconnection.getinstance().getconnection();          map.put("query", "select u.name, u.status user_info u u.user_name = 'thanuj'");          jasperreport report = jaspercompilemanager.compilereport("report1.jrxml");         jasperprint jp = jasperfillmanager.fillreport(report, map, conn);         jasperviewer.viewreport(jp, false);     } catch (jrexception ex) {         logger.getlogger(reporttest.class.getname()).log(level.severe, null, ex);     } catch (sqlexception ex) {         logger.getlogger(reporttest.class.getname()).log(level.severe, null, ex);     } catch (classnotfoundexception ex) {         logger.getlogger(reporttest.class.getname()).log(level.severe, null, ex);     } 

i figured out answer colleague. had change parameter ($p{query}) ($p!{query}) in jasper report's xml file (ex; report.jrxml)