| send report pdf through email [message #556393] |
Mon, 04 June 2012 01:37  |
annu-agi
Messages: 238
Registered: July 2005
Location: Karachi
|
Senior Member |
 
|
|
dear experts
i have installed oracle application server forms and report services, and i am deploying my forms and reports on it and its working fine, now i have a new requirement to send email through reports. I am already generating reports on pdf form and displaying on screen. How can i send this report PDF as an attachment and send it to different email addresses or how can i setup oracle application report services to send emails as an attachment .. is there any way .. any idea.. i dont now hot to do it .. i have already digg the google but i cant find any thing regarding this issue.
regards
Anwer
[EDITED by LF: removed superfluous empty lines]
[Updated on: Mon, 04 June 2012 03:22] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: send report pdf through email [message #557877 is a reply to message #556439] |
Sat, 16 June 2012 14:07  |
manirocks
Messages: 65
Registered: October 2007
|
Member |
|
|
Linux/unix:
1. Create a sh script and in the script use rwclient.sh to invoke reports and send the generated pdf to user by email
Ex: rwclient.sh report=<my_report>.rdf userid=<username>/<password>@<my_db>
server=<server_name> destype=pdf desformat=file desname=one.pdf
Use mailx command to send the one.pdf to the user.
Windows:
Create .bat file and call
rwclient report=<my_report>.rdf userid=<username>/<password>@<my_db>
server=<server_name> destype=pdf desformat=file desname=one.pdf
If you want the scripts to run in daily basis then schedule them using crontabs or batch
Hope this helps 
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
