How to call run_report_object and send an email with a pdf report as an attachament

myluism

Hi all.

I'm using Forms 12.2.1.4 on Linux and would like to run a report from forms via RUN_REPORT_OBJECT. This report will be DESTYPE=MAIL. and DESFORMAT=PDF.

Assuming the mailserver is correctly configured and every time you run a report it will be a one on one output: I mean every time you run the report you will print 1 invoice: for example you run the report the first fime and you pass parameter invoice = 10, it will print that invoice only. I only need the report output as an attachment to the mail.

My question is: will i need report distribution xml file?

myluism

Done !!!

myluism

Done !!!

Michael Ferrante-Oracle

@myluism

When you find a solution on your own, please share what you did so others can benefit from your findings.

myluism

Done !!!

myluism

Sorry Michael. I just looked at reports manual and did somthing like this:

http://yourserver/reports/rwservlet?server=your_report_server+report=your_report.rep+userid=user/[email protected]+

desformat=pdf+DESTYPE=mail+DESNAME="[email protected]"+CC="[email protected]"+BCC="[email protected]"+FROM="[email protected]"

My goal at this stage was:

1. Configure Email Server.
2. Test a simple report with destype=MAIL and desformat=PDF can be successfully sent. Report output is sent as an attachment in mail.
3.