how to have the report printed from the user's selected printer
Posted on 2002-04-18
Hello oracle masters,
Question: How do I get a report executed from a form and printed to the printer that the user chose? I need the form to run the report, then ask the user which printer he wants the report to print (list of printers = installed printers in the current client pc).
Software Info: I'm currently using ORACLE FORMS DEVELOPER 6i and Database 8i.
Sample Data: In the Sampleform.fmb, there's a button with the following 'When-Button-Pushed' trigger:
repid := find_report_object('INVOICE');
v_parameter := 'paramform=no,INVNO='||:TABLE.invno;
In the reports group of Sampleform.fmb, the INVOICE is set to the following:
Filename = print_invoice.rdf
Execution Mode = Runtime
Report Destination = Printer
The print_invoice.rdf has a user parameter INVNO and the query needs this parameter to run the form.
Any suggestions would really be appreciated....