Hi, I have just started working on Jasper. I am using iReports 2.0.5 and jasper 3. In the Report Query i have mentioned : SELECT FROM_UNIXTIME(e.timestamp/1000) as Initial,e.uniqueId,em.feature as feature, b.brandName as bName, e.appVersion FROM eventmetrics e,eventnames em,brands b where e.featureId ='AO1' and e.brandId = b.brandId and e.featureId = em.featureid and e.brandid=$P{brandname}$P{rangeparam} limit 1,10 where $P{brandname} and $P{rangeparam} are request parameters which i pass via JSPs. ALl the params are set but i get this exception : 02:27:28,324 ERROR [sTDERR] Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syn tax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' and (WEEK(FROM_UNIXTI ME(e.timestamp/1000)) = Week(CURRENT_DATE)) and (YEAR(FRO' at line 6 But when i replace the params with the values that are actually sent to the server , the same SQL works fine. It screws up. Any info would be of great help. --Venu