Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

pl/sql code help using dynamic filename

bigmac704Sep 25 2018 — edited Sep 28 2018

Hello,

I am trying to create a dynamic print button. i am using apex 18.1.    i am having an issue with the pl/sql process for printing a report using jasper reports.

here is where part of the code I am having problems with.  The part where I am tring to assign the &P13_FORM_TYPE. it does not like it written this way.  I have tried writing a number of different ways with no luck.

-- call the report and pass parameters

  xlib_jasperreports.show_report (p_rep_name => 'RCSDATA/RCS_Management_504/'||'&P13_FORM_TYPE.',

                                  p_rep_format => xlib_jasperreports.c_rep_format_pdf,

Normally this part of the code would look like this:

-- call the report and pass parameters

  xlib_jasperreports.show_report (p_rep_name => 'RCSDATA/RCS_Management_504/myfilename',

                                  p_rep_format => xlib_jasperreports.c_rep_format_pdf,

Any help is much appricated.

This post has been answered by Fernando Lima on Sep 28 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2018
Added on Sep 25 2018
13 comments
1,055 views