Email via reports.

[rcruz]

I need to generate a report that after completed Send the output to the user via email. I already tried several ways, and I discovered that the report sends the output to the automatical email configuring in the System Parameters. Someone can help me realize this setting and send the email.
Thanks in advance.

Robson: Evil ::

[dr_gori]

Speaks RCRUZ
Some parameters must be set:

Select all

DESTYPE=mail 
DESNAME=seu_email@blablabla   (separados por vírgula se for mais que um)

must have an email service running on the machine.
When I rode here on this machine for the first time, he opened a screen to set up ... try there and put the tips for us! :-O

[rcruz]

OK VEIO. It worked out but the extent he puts is .eps. In my case you need to come with the .doc or .pdf extension. You know how I do it.

grateful: -O: -O

[dr_gori]

I found a paper in Metalink that talks about it (I will attach it below)

According to paper, the reasons to be happening This can be:
* Has a client of Email running, Exchange type or Netscape
* or, reports are sending for a type of "driver" of printed ...

to change, you should do so:

Method 1:
Send direct to the person's mail (without sending to the screen), with the following settings:

Select all

DESTYPE: MAIL 
DESFORMAT: PDF or HTML 
DESNAME: blablabla@email.com

Method 2:
Registering the report, through a button.
puts a button on the Layout Editor calling "Email"
Then put the code that is below ... (take a look)


] Doc ID: Note: 106549.1
Subject: How to Send Oracle Reports Output via Email in Specic Format Other Than EPS?
Type: bulletin
Status: Published

Content Type: Type: Text / Plain
Creation Date: 26-APR-2000
Last Revision Date: 09-Dec-2003

Purpose

--------------

You are Trying to Send An Oracle Report Output via email and the output

Is in PostScript. Instead You would like to send it in pdf or html format.

Scope & Application

--------------------------- ----------

This document describes how to send reports output via email in different

formats other than the default PostScript Format for Instance PDF, HTML ... etc.

The Document Assumes That Email Client is Already Setup on the PC and Reports
Could be successfully.

How To Send Oracle Reports Output via Email In Specific Format Other Than EPS?

Why Emailing Reports Output is PostScript (EPS) Format:

------------------ -------------------------------------------------- ------------

- You have the MAPI Email Complaint Setup. I.E. Netscape Messenger or MS Exchange.

- You have the Report Running in the Previewer and Would Like to email it

- The Reports Previewer Formats The Output in PS, Because It is the script That

The Printers Use to produce Bitmap Output. So when you email the output using the

Previewer Directly it is attached to your email the PS document.

- To View The Document You Need A PostScript Viewer Like Ghost View.

Emailing Report Output In Other Formats:

----------------------- --------------------------------

There are Two Methods to Email The Report OUTPUT IN HTML, PDF OR RTF FORMAT:

Method 1: Directly Email The Output

-------------

This is Done by Directing the Email Output to be Directly Sent via Email Without Previewing IT
In the Report Previewer,

THIS IS ACHIVED BY SETTING THE FOLLOWING PARAMETERS:
Destype: Mail
DESFORMAT: PDF OR HTML

Desname: Name of the email id ie jaburrub@aí.oracle.com

The result Will Be an email Message with the output attached The Target Format.

Method 2: Have a look at the Output in the Previewer Before emailing IT

---------------

Since the Reports Previewer Formats The Output in PS, You Need To Reformat (Re-Run)
The Report Again in The Required Format. In Order to SO Follow These Steps:

- Add a Button in the Report Layout Editor.

- Label The Button 'Email The Output'

- In The Button PL / SQL Use srw.run_report to call The Same Report Again with the

Following Parameters:

Destype: Mail
DESFORTAT: PDF OR HTML

Desname : Name of the email id ie jaburrub@aí.oracle.com

Batch: Yes

SRW.Run_Report Examples in the online Help of Oracle Reports

/ * Suppose You have the Following Two Reports:

** MGR_RUN, WHICH DERIES Manager names, and Invokes a Second Report Named Mail_it

** Mail_it, WHICH Queries Employee Names for The Manager That MGR_Run Passes IT,

** And Sends The Report Output to The Manager via e-mail.

** The description of mgr_run could be the follows:

** Query:

Select all

SELECT ENAME, EMPNO FROM EMP WHERE JOB='MANAGER'

** Group Filter:

* /

Select all

FUNCTION FOO RETURN BOOLEAN IS 
 
BEGIN 
 
srw.run_report('report=MAIL_IT 
 
desname='||:ename ||' desformat=html batch=yes 
 
mgr_no='|| TO_CHAR(:empno) ); 
 
RETURN (TRUE); 
 
EXCEPTION 
 
when srw.run_report_failure then 
 
srw.message(30, 'Error mailing reports.'); 
 
raise srw.program_abort; 
 
END;

/ * This PL / SQL Invokes Mail_it , Specifies That Mail_It's Output

** Should Be Sent To The Manager via Oracle Mail, and passes the

** Manager Number, So that The Mail_it Report Can Query Only The

** Manager's Employees.

** Note: Empony's Values ??Must Be converted to characters

** (To_Char in the PL / SQL Above), Because srw.run_report
]
** Requires to Character String.

** Layout: None Is Needed, Because This Report Only Fetches Date,

** Then Passes IT TO A Second Report.

** The Description of Mail_it Could Be the follows:

** Query:

Select all

SELECT DEPTNO, ENAME, SAL FROM EMP WHERE MGR=:MGR_NO

** Layout: Master / Detail

* /

/ * Suppose That You Have Three Reports That You Almost Always Run Together.

** THE REPORTS ARE NAMED SALARY, COMMISS, AND FATES. To Run These Reports

** With One R30run Command, You Create The Report Named PAYROLL Driver.

** The description of PAYROLL COULD BE THE FOLLOWS:

** Query:

Select all

SELECT DEPTNO FROM DEPT

** Before Report Trigger:

* /

Select all

FUNCTION FOO RETURN BOOLEAN IS 
 
BEGIN 
 
srw.run_report('batch=yes report=SALARY 
 
destype=file desformat=dflt desname=salary.lis'); 
 
srw.run_report('batch=yes report=COMMISS 
 
destype=file desformat=dflt desname=comiss.lis'); 
 
srw.run_report ('batch=yes report=TAXES 
 
destype=file desformat=dflt desname=comiss.lis'); 
 
RETURN (TRUE); 
 
END;

/ * Layout: tabular

** When You Run Payroll from The Designer or R30run, The Other Three

** Reports Will All Be Run. (Note That, In This Case, The Query and

** The layout for Payroll Could Be Anything. They Are Only Used Here

** In Order to make it possible to run payroll.)

* /

- Simple Example

Select all

procedure U_1ButtonAction is 
 
begin 
 
srw.run_report('report=emp.rdf destype=mail desname=jaburrub@aí.oracle.com desformat=PDF 
 
batch=yes'); 
 
end;

Summry:

--------------

In Order to Email The Report in A Desired format other than the default ps format,

re-run the report in batch mode to generate the output in the desired format.

Related documents

---------------------------- -----------

Oracle Reports Online Help

References:

- -----------

Bug 1273155: Changing The Name Of The Attachment Which Is Send (Enhancement Request)

Bug 583949: Possibility to SEND A SUBJECT LINE (ENHANCEMENT REQUEST) [/quote]

[rcruz]

It worked as a PDF. But there is a probem. Via Application does not work. Is there a way to do this to work on Application ???
: -The Robson: -O

[tchuck]

To send more than one person can not make separated by Virgula until now I did not find it way to do this. I already tested with virgula, with point and virgulum, spaces, several modes .. I did not have another option not to make a loop and get an email at a time.
Hugs

[roots17]

Good Morning.

Someone already managed to make the report send the PDF attacked in an e-mail, automatically, in the Application?

Great Abraco

[eng.nunoneves]

Good morning,

Does anyone know how to change the name of the attached file?
Thank you for help, thank you!

Greetings,
Nuno Neves.

[eng.nunoneves]

Changing the name of the attached file when sending is via Reports Server.
Thanks! [/ U]