| Batch submission form - need to output PDF's [message #656602] |
Wed, 12 October 2016 09:11  |
 |
J_Luff
Messages: 2
Registered: October 2016
|
Junior Member |
|
|
|
We use a form to submit a batch of reports - using RUN_REPORTS and WEBFORM_PKG. The user still wants to receive the batch of reports each week. Along with that, they want to be able to run a similar program that puts out PDF's for those same reports. What changes need to be made in the WEBFORM package and run reports to put out the PDF file....I need to know the parameters to use for the format(PDF)....the file name(what to call it and where to put it)...and the destination type(FILE).
|
|
|
|
|
|
| Re: Batch submission form - need to output PDF's [message #656653 is a reply to message #656652] |
Thu, 13 October 2016 08:59  |
|
J_Luff
Messages: 2
Registered: October 2016
|
Junior Member |
|
|
This is how it looks now....an example of one report it runs from RUN_REPORTS:
webform_pkg.build_report_groups(lv_report_param_grp,
lv_report_print_grp,
lv_report_email_grp);
lv_report_name := 'BS_CBIP';
webform_pkg.add_report_param_group_row (p_report_name => lv_report_name,
p_report_param_grp => lv_report_param_grp,
p_parameter_name => 'P_END_DATE',
p_default_value => To_Char(:end_date,'MM/DD/RRRR'));
webform_pkg.add_report_param_group_row (p_report_name => lv_report_name,
p_report_param_grp => lv_report_param_grp,
p_parameter_name => 'P_SOLD_INCLUDE',
p_default_value => 'INCLUDE');
webform_pkg.add_report_print_group_row (p_report_print_grp => lv_report_print_grp,
p_printer_name => :dsp_printer,
p_copies => '1');
webform_pkg.call_report(p_report_name => lv_report_name,
p_report_comm_mode => lv_report_comm_mode,
p_report_output_type => lv_report_output_type,
p_report_background => lv_report_background,
p_report_param_grp => lv_report_param_grp,
p_report_print_grp => lv_report_print_grp,
p_report_group_id => lv_group_id);
webform_pkg.remove_report_groups(lv_report_param_grp,
lv_report_print_grp,
lv_report_email_grp);
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
