I have a report that runs in the BCA scheduler.
When it runs it asks for a date prompt.
I need to have it run daily at 11pm using “today’s” date.
So today it will use 11/30/04, and tomorrow it will use 12/01/04, etc…
How can I set this up? I am running Business Objects 6.5.1 on win2000 with a MS SQL repository. I am new to BO.
thanks in advance!
ego (BOB member since 2004-11-01)
Welcome to B:bob:B!
Here is a nice FAQ I wrote, it should point you in the right direction.
Nick Daniels 
(BOB member since 2002-08-15)
In my opinion then you loose functionality. In another topic here I already suggested my solution (which is also a predefined condition 
):
When we have a report with prompt which is used by users as well as BCA we create double prompts like " = Decode(@prompt(“startdate or 0 for sysdate”), 0, Trunc(sysdate), @prompt(“startdate or 0 for sysdate”))". Users just fill in the date they want, and when it is sent to the BCA you fill in 0 and the prompt will be automatically filled.
Nick, this might be an addition for the FAQ 
HenkK
HenkK 
(BOB member since 2004-03-02)
Leave it with me… 8)
Nick Daniels (BOB member since 2002-08-15)
Done, I hope it reads ok.
Nick Daniels (BOB member since 2002-08-15)
Nick,
I feel honoured to have (finally) made the BOB FAQ 8)
HenkK
HenkK (BOB member since 2004-03-02)
I also like this solution offered by Steve Krandel:
Andreas 
(BOB member since 2002-06-20)