Jump to content
We've recently updated our Privacy Statement, available here ×

remyasr

Members
  • Posts

    1
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by remyasr

  1. 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_ExpirationDate
    FROM
         `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_Pos

    it showing error
    "Parameter type not supported in query : start_date class net.sf.jasperreports.types.date.DateRange".
     
    How can i  fix the issue???
×
×
  • Create New...