Hi,
I have a DATE LOV (with about 10 dates as of now) and I want to burst this report to few recipients. While Scheduling, we want to populate a default value in Prompt which is the maximum value of the Prompt LOV.
I understand BO doesn’t offer a completely flexible solution to implement default value in Prompt (and also that we can have few workarounds), but has anyone implemented such a functionality? I was just wondering, how do we schedule such reports with date prompt in BO in such a way that the report gets scheduled every month/week/quarter with updated value of the Date LOV (in my case, it should take the maximum value of Date every month while scheduling).
Currently, I am trying to work with the Prompt query, trying to code an optional prompt (using CASE statement), but then is it the only solution?
Thanks.
Rajat Sapru 
(BOB member since 2008-08-28)