this is a snippet of my java: Code:String startDate = request.getParameter("dateFrom"«»); String endDate = request.getParameter("dateTo"«»); System.out.println("start: " + startDate); System.out.println("end: " + endDate); Map parameters = new HashMap(); parameters.put("ReportTitle", "PDF JasperReport"«»); parameters.put("StartDate", startDate); parameters.put("EndDate", endDate); InitialContext initialContext = new InitialContext(); DataSource ds = (DataSource)initialContext.lookup("java:comp/env/jdbc/StrutsSkeleton"«»); Connection conn = ds.getConnection(); JasperPrint print = JasperFillManager.fillReport(report, parameters, conn); and this is my jrxml code: Code:[code]<parameter name="StartDate" isForPrompting="false" class="java.lang.String"/> <parameter name="EndDate" isForPrompting="false" class="java.lang.String"/> <queryString><![CDATA[sELECT * FROM (SELECT a.*, ROWNUM rnum FROM (SELECT * FROM SALES_TRANSACTION WHERE VENDOR_ID LIKE '%' AND TRANS_DATE BETWEEN $P{StartDate} AND $P{EndDate} ORDER BY TRANS_TIMESTAMP DESC) a WHERE ROWNUM <= 30) WHERE rnum >= 1]]></queryString> and i go this error when generating the report Error: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : PDFReport anybody can help? thank you in advance.