Home » Developer & Programmer » Forms » Using HOST to print a Report from FORM
Using HOST to print a Report from FORM [message #77795] Wed, 21 November 2001 05:05 Go to next message
Ben
Messages: 48
Registered: January 2000
Member
Does anyone know how to write a WHEN-BUTTON-PRESSED trigger to print a specific Report run in Batch Mode from a Form using the built-in package HOST?

----------------------------------------------------------------------
Re: Using HOST to print a Report from FORM [message #77816 is a reply to message #77795] Mon, 26 November 2001 23:28 Go to previous messageGo to next message
Kurt
Messages: 11
Registered: September 2000
Junior Member
Why don't you use the RUN-PRODUCT built-in or the RUN-REPORT-OBJECT (the last one is only available in forms 6 I think) built-in

----------------------------------------------------------------------
Re: Using HOST to print a Report from FORM [message #77818 is a reply to message #77795] Tue, 27 November 2001 04:05 Go to previous messageGo to next message
Ben
Messages: 48
Registered: January 2000
Member
Could you please be more specific on how to use RUN_PRODUCT to print a Report from a Form?
Any example?

----------------------------------------------------------------------
Re: Using HOST to print a Report from FORM [message #77820 is a reply to message #77818] Tue, 27 November 2001 05:12 Go to previous message
Kurt
Messages: 11
Registered: September 2000
Junior Member
Syntax : RUN_PRODUCT(product, document, commmode, execmode, location, list, display);

product => REPORTS
document => the name of the report
commode => Specifies the communication mode to be used when running the called product.(SYNCHRONOUS or ASYNCHRONOUS)
execmode => Specifies the execution mode to be used when running the called product.(BATCH or RUNTIME)
location => Specifies the location of the document or module you want the called product to execute, either the file system or the database.
list => Specifies the parameter list to be passed to the called product.(If you don't use a paremeter list, use NULL)
display => Specifies the CHAR name of the Oracle Forms chart item that will contain the display (such as a pie chart, bar chart, or graph) generated by Oracle Graphics.(NULL if you don't use this)

Example :
RUN_PRODUCT(REPORTS, 'F:repsclrep044', ASYNCHRONOUS, BATCH, FILESYSTEM, NULL, NULL);

Also see the 'help' in forms.

----------------------------------------------------------------------
Previous Topic: Re: Pro*C: passing username and password into program
Next Topic: execute_query
Goto Forum:
  


Current Time: Fri Mar 29 04:09:15 CDT 2024