Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to print reports on forms
- Thread starter LimonaM
- Start date
You can use RUN_PRODUCT built-in in When-Button-Pressed trigger.
Here is an example for sending a report directly to the printer:
pl_id ParamList := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'Printer');
/* Run the report synchronously,passing the parameter list */
Run_Product(REPORTS, 'my_report', SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);
Here is an example for sending a report directly to the printer:
pl_id ParamList := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'Printer');
/* Run the report synchronously,passing the parameter list */
Run_Product(REPORTS, 'my_report', SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);
- Status
Similar threads
