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

    Cascading Parameters with date parameter BI Publisher 11.1.1.5

    934010
      Hi,

      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 11.1.1.5 version

      Please let me know the work around.

      Regards,
      Hemanth.