Prompt For No. of days

Hi,

I have a report which contains the

Complete_date
Processing_time
Count Of Orders
Sales Order
Release Date

The user wants a Prompt for the no. of Days
andit should be defaulted to 7 days
Suppose if he enters :5
then current date -4days data should be diplayed for him.
Suppose the Current Date is:07/15/2004 then he should get the data from 07/10/2004 to 07/15/2004.
Can anyone tell me the syntax of that condition.
Thanks


randyj262004 (BOB member since 2004-04-09)

It depends on your database, but here is an Oracle example:

Table.DateField BETWEEN trunc(SYSDATE) - (@Prompt('Enter number of days to include in the report', 'N', , MONO, FREE) - 1) AND trunc(SYSDATE)

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Keep in mind that Business Objects does not provide a direct way to provide a default value for prompts (maybe in WebI v6, but I am not sure).


Andreas :de: (BOB member since 2002-06-20)

Andreas is correct. A workaround is discussed here.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)