OraFAQ Forum: Forms » Sending report as attachment from forms

Home » Developer & Programmer » Forms » Sending report as attachment from forms (Oracle Forms & Reports 11g, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sending report as attachment from forms [message #675688]

Fri, 12 April 2019 04:21

saiphani723
Messages: 38
Registered: July 2006
Location: Hyderabad

Member

I am using the below code to send report as attachment through mail.

Add_Parameter(Pl_Id,'REPORTFORM', TEXT_PARAMETER,'NO');
Add_Parameter(Pl_Id,'PARAMFORM', Text_Parameter, 'NO');
Add_Parameter(Pl_Id,'PCOMPANYCODE',Text_Parameter,:Global.CompanyCode);
Add_Parameter(Pl_Id,'PUNITCODE',Text_Parameter,:Global.UnitCode);
Add_Parameter(Pl_Id,'PFUNDTYPE',Text_Parameter,:Parameter.FundType);
Add_Parameter(Pl_Id,'PFROMRECEIPTNO',Text_Parameter,:Parameter.ReceiptNo);
Add_Parameter(Pl_Id,'PLINKID',Text_Parameter,:Master.LinkId);
Show_View('EMAIL');
Rp2rro.setDestype('mail');
Rp2rro.setDesformat('pdf');
--Rp2rro.setDesname('saiphani723@gmail.com');
Rp2rro.setDesname(:Control.EmailId);
ADD_PARAMETER(Pl_Id, 'FROM',TEXT_PARAMETER, pSender);
ADD_PARAMETER(Pl_Id, 'SUBJECT',TEXT_PARAMETER, 'Receipt for '||:Master.ReceiptNo);
ADD_PARAMETER(Pl_Id, 'BODY',TEXT_PARAMETER, 'TEST MAIL');
ADD_PARAMETER(Pl_Id, 'MESSAGE',TEXT_PARAMETER, 'TEST MAIL');

RP2RRO.RP2RRO_RUN_PRODUCT(REPORTS,LvReportId,SYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,null);

Report is attaching as pdf and sendin mail But no body/message coming in the mail. Can you please suggest how to send some mail body using the above code.

Report message to a moderator

Previous Topic:	slow laoding webutil package just the first time
Next Topic:	Temporary table in forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 21:59:34 CST 2025