| report expire [message #601795] |
Mon, 25 November 2013 22:22  |
 |
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
|
Junior Member |
|
|
hello,
In my company we give the reports for testing on the desktop as shortcut,i want the reports get expire after 5 days automatically,is this possible,if possible please tell the solution for that.
thanks.
|
|
|
|
|
|
| Re: report expire [message #601817 is a reply to message #601797] |
Tue, 26 November 2013 00:57  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
One option is to hardcode date into report's query, for example
select * from dept where trunc(sysdate) - date '2013-11-22' < 5;
Therefore, you might create a database function (which would, basically, do the same - check whether 5 days have passed since some date) and call it from BEFORE REPORT trigger. If the result returned by function is unfortunate for the client, use SRW.PROGRAM_ABORT and terminate report execution. If you change your mind, it is easier to recompile the function (or, if it uses date(s) stored in some table, you don't even have to do that but just update tables' contents).
|
|
|
|
|
|
| Re: report expire [message #601819 is a reply to message #601818] |
Tue, 26 November 2013 01:21 |
|
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
Thank you very much for detailed explanation of what you did, what code you wrote, the way Oracle responded etc. It is now very easy to debug your code and point you into the right direction.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
