How to pass parameters in the query

[anshukunal]

Hi,

 

How to pass parameters in the sql query in the jasper report via java code.

I am attaching codes which i am using.

 

Code:

.jrxml file<parameter name="REPORT_PARAMETERS" class="java.lang.String"/>	<parameter name="REPORT_PARAMETER" class="java.lang.String"/>	<queryString>		<![CDATA[select * from Info_Log where $P{REPORT_PARAMETERS}=$P{REPORT_PARAMETER}]]>	</queryString>This code didn't worked.Then i tried :<![CDATA[select * from Info_Log where $P!{REPORT_PARAMETERS}=$P!{REPORT_PARAMETER}]]>This gave some sql error.I am able to generate the report passing one parameter in sql query but not with 2 parameters at the same time.<![CDATA[select * from Info_Log where NAME=$P{REPORT_PARAMETER}]]>	</queryString>my java code for taking parameters is:Map parameters = new HashMap();    parameters.put ("REPORT_PARAMETERS","reader");    parameters.put("REPORT_PARAMETER","reader1"); JasperPrint jasperPrint = JasperManager.fillReport(jasperReport,parameters, connection);

[anshukunal]

Issue got fixed.

[coolabhaymishra]

please explain how??