remyasr Posted April 4, 2014 Share Posted April 4, 2014 i am using two date parameters $P{StartDate} AND $P{EndDate} and having a query like SELECT DISTINCT expirydate.`ArticleName` AS expirydate_ArticleName, medicinelist.`Pos` AS medicinelist_Pos, medicinelist.`Quantity` AS medicinelist_Quantity, expirydate.`ExpirationDate` AS expirydate_ExpirationDateFROM `expirydate` expirydate INNER JOIN `medicinelist` medicinelist ON expirydate.`Barcode` = medicinelist.`Barcode`WHERE expirydate_ExpirationDate BETWEEN $P{start_date} AND $P{end_date}order by medicinelist_Posit showing error"Parameter type not supported in query : start_date class net.sf.jasperreports.types.date.DateRange". How can i fix the issue??? Link to comment Share on other sites More sharing options...
mlopez_1 Posted April 4, 2014 Share Posted April 4, 2014 Take a look at iReport Designer ultimate guide, DateRange only works with $X{..} Link to comment Share on other sites More sharing options...
sumayya.sultana Posted June 29, 2015 Share Posted June 29, 2015 Hi, You have used two parameters $P{StartDate} AND $P{EndDate} but in query you are usingWHERE 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now