Home » Developer & Programmer » Reports & Discoverer » Report output to mail
Report output to mail [message #283479] Tue, 27 November 2007 05:21 Go to next message
vidya.soujanya
Messages: 4
Registered: August 2007
Location: chennai
Junior Member
hi,
Can any one help me how to sent the output of a report to mail.

I have generated a report(Test1.rdf). If i click on a hyperlink on that report that should be sent to a particular mail id

OR

The report output should be sent to a particular mail Id.

Is this possible in reports10g? If so , Please help me how to do the same

[Updated on: Tue, 27 November 2007 05:22]

Report message to a moderator

Re: Report output to mail [message #283679 is a reply to message #283479] Tue, 27 November 2007 23:18 Go to previous messageGo to next message
informkar
Messages: 4
Registered: November 2007
Location: tvm
Junior Member
refer this document buddy....

http://download-uk.oracle.com/docs/cd/B10464_03/bi.904/b13673/pbr_cla.htm#g770226

regards,
karthik.
Re: Report output to mail [message #283719 is a reply to message #283679] Wed, 28 November 2007 00:49 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There have been similar questions here, so - you might check what the OraFAQ Search engine found, study what other people have said and, eventually, use (or combine) their suggestions.
Re: Report output to mail [message #283813 is a reply to message #283719] Wed, 28 November 2007 03:41 Go to previous messageGo to next message
vidya.soujanya
Messages: 4
Registered: August 2007
Location: chennai
Junior Member
Thanq very much for ur suggestion ....

I tried in the below manner:

:p_mail_hyperlink := :p_report_call||'?'||:p_rep_userid||'&server='||:p_reports_server||'&report=Test_self_bill&destype=Mail&desformat=pdf &DESNAME=' ||'xyz@gmail.com'||'&replyto=aaa@gmail.com' ||'&from=aaa@gmail.com'||'&p_gl_user='||:p_GL_USER||'&p_within_report=Y';

I am trying to execute the report from the web:
there is no error. it is showing in the front end screen "Job done Sucessfully"

But

No mail have been received.....
should i need to change any setting in Mailing Sever or at any other place?

Can any one help me out....

[Updated on: Wed, 28 November 2007 04:09]

Report message to a moderator

Re: Report output to mail [message #284171 is a reply to message #283479] Thu, 29 November 2007 01:35 Go to previous message
informkar
Messages: 4
Registered: November 2007
Location: tvm
Junior Member
As per the document the configuration file rwbuilder.conf must include the pluginParam mailServer with the outgoing mail server name.which environment are u workin..?
linux or windows?
Previous Topic: 2 query
Next Topic: How to get length of column data in oracle form
Goto Forum:
  


Current Time: Wed Jul 03 00:47:24 CDT 2024