Home » Developer & Programmer » Forms » Batch submission form - need to output PDF's (Oracle 11g)
Batch submission form - need to output PDF's [message #656602] Wed, 12 October 2016 09:11 Go to next message
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 #656652 is a reply to message #656602] Thu, 13 October 2016 08:48 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
add_parameter desformat pdf

filename and destination have similar parameters. It's well documented.
Re: Batch submission form - need to output PDF's [message #656653 is a reply to message #656652] Thu, 13 October 2016 08:59 Go to previous messageGo to next message
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);
Re: Batch submission form - need to output PDF's [message #656666 is a reply to message #656653] Thu, 13 October 2016 16:02 Go to previous message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
I am unfamiliar with webform_pkg. Look at the documentation for it and I am sure you'll find the parameters for format and location.
Previous Topic: Capturing incoming Phone number in Forms
Next Topic: how to get weight in oracle forms from weighment machine
Goto Forum:
  


Current Time: Sun Jun 13 12:26:21 CDT 2021