OraFAQ Forum: Reports & Discoverer » Discoverer parameter default SYSDATE

Home » Developer & Programmer » Reports & Discoverer » Discoverer parameter default SYSDATE (OracleBI Discoverer 10g (10.1.2.3))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Discoverer parameter default SYSDATE [message #569469]

Fri, 26 October 2012 15:29

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.........

Report message to a moderator

Re: Discoverer parameter default SYSDATE [message #569481 is a reply to message #569469]

Sat, 27 October 2012 02:09

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Discoverer parameter default SYSDATE [message #569511 is a reply to message #569481]

Sun, 28 October 2012 11:09

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

Report message to a moderator

Previous Topic:	how to create link file dynamically in oracle reports 6i
Next Topic:	Send Report as attached

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 20:54:29 CST 2025