3 Replies Latest reply: Feb 13, 2013 12:31 AM by Kishore Rout RSS

    Cascading Parameters with date parameter BI Publisher


      I am working on BI Publisher. I have a situation of cascading the parameters.

      Parameter a(start date) date, paremeter b(end date) Date, Parameter C string.

      Parameter C needs to retrive all distinct Values based on start date and end date.

      when I use the above sitution like this

      Select distinct ID from table1 a
      where a.et_date>=:parametera
      and a.et_date<=:parameterb

      I am getting the below error.
      org.xml.sax.SAXException: Date format can not be null

      I am working on BI Publisher version

      Please let me know the work around.