Re: Passing Parameters to Reports from Forms

Chad Edwards wrote:
>
> Can someone please explain how I pass a parameter to reports from forms?
>
> What I want to do, is this:
>
> User is presented a form with a print all, print one set, and print one
> button. I want, if the user clicks on print all to print all of the
> "documents". If the user clicks on print one set, it will print all
> documents with and id equal to some number provided by the user after he
> or she clicks the print one set button. Finally, if the user clicks print
> one, it will ask him or her to enter the name of the "document" they wish
> to print and pass that.
>
> My question is how do I set up my form to correctly do this, and how do I
> modify my report as to handle this?

  You can use RUN_PRODUCT to run report from the Forms and pass parameters.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.