Re: Interesting forms/reports challenge, What's the best way?

steve deno wrote:

>Hi all,
>
>I am using 9ids forms and reports with Oracle 9iAS Release 2. My
>database is only 8.1.7 I am deploying forms on the web.
>
>My cahllenge is: To have a button on a form which:
>
>1. Commits the form changes
>2. runs a report
>3. Saves the report(Either in the database or on the appServer,
>preferably the db)
>4. Emails the report
>5. Makes a link to the report available to the user of the form via a
>detail block, along with all the other links from previous reports
>related to the parent.
>
>So far, I have a table for storing information about the
>reports(Filename, parent ID for retrieving the appropriate set of
>records, type, etc) And if I get the report saved on the server, I
>can use web.show_document to view it via the link in the table.
>
>I'm wondering
>1. if anyone has done this before?
>2. Should I employ webutils PJC for this? I can't save them in the
>database because evidently this part of webutils requires a 9+
>database.
>3. What's the best way to save the report?
>
>4. Any other comments?(Please go easy on me as I just installed
>reports 9i and have not written reports in a long time)
>
>Thanks VERY much
>
>
Did you look at the options under parameter form? The best way ... is to use the native functionality that already exists.

Daniel Morgan

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)