This discussion is archived
3 Replies Latest reply: Feb 12, 2013 10:31 PM by Kishore Rout RSS

Cascading Parameters with date parameter BI Publisher 11.1.1.5

934010 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points