Home » Developer & Programmer » Reports & Discoverer » To run Dynamic reports from Forms 9i
To run Dynamic reports from Forms 9i [message #88764] Mon, 10 March 2003 12:56
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.
Previous Topic: Reports formatting
Next Topic: Need info on Exporting to Excel, Word, etc.
Goto Forum:
  


Current Time: Thu Mar 28 11:29:27 CDT 2024