sysdate as a default value in prompt.

building reports webintelligence
1

Hello all …
as per requirement, we have one prompt “Enter End Date” and we have to show SYSDATE as a default value for this prompt.

If anyone could help me out, that would be great help …

Thanks in advance…

Vills :india: (BOB member since 2007-10-24)

2

It’s the right time to read this blog of Dave. :wink:

Jansi :india: (BOB member since 2008-05-12)

3

You may be able to use Sysdate as default if you create your prompt filter at the report level instead of in the universe.

rktarapore (BOB member since 2006-11-14)

4

Thanks Jansi … for the nice blog link…

however, as per blog we have to enter magic date “1900-01-01” manually… which elp in report scheduling only.
and our requirement is like, when ever we refresh report and PROMPT dialog box will appear … END DATE prompt must have sysdate as a default date each time…

Vills :india: (BOB member since 2007-10-24)

5

Thanks “rktarapore” …
please … can u povide more details… and if possible with example …

thanks a lot (in advance) …

Vills :india: (BOB member since 2007-10-24)

6

I am sorry the method I suggested is also only used for schedulling a report. The date is default date and the user does not have to enter it.
This is done by creating an object in the universe say Today’s date, assign sysdate to it. Then in the report create a filter: table.date_field Equal to (Click Object from this Query, select the object Today’s date).

rktarapore (BOB member since 2006-11-14)