| To run Dynamic reports from Forms 9i [message #81675] |
Mon, 10 March 2003 13:03 |
Swamy
Messages: 78
Registered: June 2002
|
Member |
|
|
|
I am using Oracle Forms 9i and Reports 9i. I created some RDF and then REP files for static reports and every day I am executing these reports from Unix command line by nightly process with shell scripts. They will produce both PDF and EXCEL outputs. I called the TEXT_IO built-in in the After Report trigger to get the excel outputs. The user can see these reports through Forms where web.show_document built-in is called. These are working fine. Now I need to produce dynamic reports in both pdf and excel formats whenever a user selects the criteria. There are four types of users and based up the type of user I need to modify the where clause in the report’s query. How can I achieve this? If they produce pdf and excel reports on the server then how can I remove these files from the server after the purpose is over? I appreciate for your help in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
