Hi, You have used two parameters $P{StartDate} AND $P{EndDate} but in query you are using WHERE expirydate_ExpirationDate BETWEEN $P{start_date} AND $P{end_date} you have to useWHERE expirydate_ExpirationDate BETWEEN $P{StartDate} AND $P{EndDate} this will work. Let me know if you face any problem