Home » Developer & Programmer » Reports & Discoverer » Discoverer parameter default SYSDATE (OracleBI Discoverer 10g (10.1.2.3))
icon5.gif  Discoverer parameter default SYSDATE [message #569469] Fri, 26 October 2012 15:29 Go to next message
DNELSON
Messages: 2
Registered: October 2012
Location: S. Calif.
Junior Member
I've hunted everywhere, and I'm beginning to think this is impossible, however I'll give it a shot...

I would like my Discoverer report start date/end date to default to YESTERDAY.

Can it be done? Thanks in advance.........
Re: Discoverer parameter default SYSDATE [message #569481 is a reply to message #569469] Sat, 27 October 2012 02:09 Go to previous messageGo to next message
Littlefoot
Messages: 18834
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't use Discoverer so - this might be completely useless.

I'm not sure what you meant to say - is it that you can't set the start/end date values to "yesterday" (which would be SYSDATE - 1 or, probably even better, TRUNC(SYSDATE) - 1), or that you already know that but Discoverer won't accept it, or that you can't set the date values at all.

If "today - 1" doesn't solve your problem, I'm sorry, I can't help any better. Hopefully, someone who uses Discoverer will be able to assist.
Re: Discoverer parameter default SYSDATE [message #569511 is a reply to message #569481] Sun, 28 October 2012 11:09 Go to previous message
DNELSON
Messages: 2
Registered: October 2012
Location: S. Calif.
Junior Member
Thanks for the reply.

Discoverer will permit SYSDATE, but it chokes on SYSDATE-1, or TRUNC(SYSDATE)-1. I think it doesn't handle defaults properly.
In fact, Discoverer Plus will not permit function calls in conditions either, whereas Discoverer desktop will. Sad
Previous Topic: how to create link file dynamically in oracle reports 6i
Next Topic: Send Report as attached
Goto Forum:
  


Current Time: Mon Apr 21 05:21:50 CDT 2014

Total time taken to generate the page: 0.11140 seconds