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)