NVL in prompt on date in derived table

[saikumar1]

hi

needed some help in derived table end date is bind variable data base is oracle

like this how to apply prompt on this  if end Date =0 or no value could accept in prompt

ch.endDate <= nvl(:end Date,ch.endDate)

i've tried in report level but optional prompt is not available could you please help me out of this

[Former Member · Accepted solution]

Could you please elaborate the problem. Like what tool you are using(IDT or UDT) and which reporting tool?

You could do optional prompt for derived tables in IDT.

Thanks

Sambit

[saikumar1 · Accepted solution]

hi

i got solution i'm using udt

Hi

derived table will not pass null values using @prompt

use this formula

To_date(CASE WHEN @prompt(':bind variabe','D',,mono,free,persistent,{'01/01/2099'}) = '01/01/2099' then to_char(ch.end_date) else @prompt(':bind variabe','D',,mono,free,persistent,{'01/01/2099'}) END)

for only in this situation it will work ch.end_date=NVL(:end date,ch.end_date)

thanks

Ravi Kumar

[Former Member · Accepted solution]

If you think it has been answered , Please close the thread.

Regards

Sambit