Re: Calling Report from a Form

There is a built-in in forms called RUN_PRODUCT which allows you to call a report from a form. Also, you can build a parameter list which can be passed to your report as well.

If you search for run_product and create_parameter_list in forms help, it should tell you all you need to know.

Mark

Shelli D. Orton wrote in message <378370A8.4FC67923_at_crha-health.ab.ca>...
>I'm a co-op student trying to build a small application and learning as
>I go. I would like to be able to have a push button on a form that when
>triggered will run an Oracle report. I have read a couple of books,
>done searches on the web and have not been able to find anything.
>Someone suggested that I would have to send a Unix command calling the
>report from the program unit that the button triggers. I don't know
>Unix, so I'm still lost. I would also like to be able to submit
>run-time parameters to the report. I believe the best way to do this
>would be to have another form activated when the report button is pushed
>and have the user input the info in text fields that can be captured as
>variables and used in the call to the report.
>
>Can anyone tell me how to do this or point me in the direction of a good
>resource to help me?
>
>Thanks, Shelli Orton
>
Received on Wed Jul 07 1999 - 17:29:11 CEST