jeevan.n

Thank you all for your quick support on the replies. I was able to make some headway but again having another issue while running the report. Any help is highly appreciated. 1. Created a new Parameter with the following Name: Parameter4 Class: java.sql.Timestamp Default Value Expression: new SimpleDateFormat("MM/dd/yy HH:mm a").format(new java.sql.Timestamp( System.currentTimeMillis() - 24 * 3600 * 1000)) 2. And I called the Parameter in query like below SELECT * FROM casd."in" WHERE open_date < $P!{Parameter4} 3. I get the following error message. "net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query:"

Hi, I have a report that is pulling records from a table and i have to limit the sql query to pull the records from only previous date. Am not sure how this can be done as am very new to the Jaspersoft Studio. I have a "open_date" column in the select statement from the table which is returning the value e.g., in the format 8/22/19 9:23 AM [M/d/yy h:mm a] but i would like to limit the query result for only previous date in the where clause by using a Parameter. Appreciate some advise here. Thanks,