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 ::
Email via reports.
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Speaks RCRUZ
Some parameters must be set:
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
Some parameters must be set:
DESTYPE=mail
DESNAME=seu_email@blablabla (separados por vírgula se for mais que um)
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
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
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:
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:
** Group Filter:
* /
/ * 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:
** 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:
** Before Report Trigger:
* /
/ * 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
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]
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:
DESTYPE: MAIL
DESFORMAT: PDF or HTML
DESNAME: blablabla@email.com
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 ENAME, EMPNO FROM EMP WHERE JOB='MANAGER'
* /
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;
** 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 DEPTNO, ENAME, SAL FROM EMP WHERE MGR=:MGR_NO
* /
/ * 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 DEPTNO FROM DEPT
* /
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;
** 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
procedure U_1ButtonAction is
begin
srw.run_report('report=emp.rdf destype=mail desname=jaburrub@aí.oracle.com desformat=PDF
batch=yes');
end;
--------------
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]
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
Hugs
-
- Rank: Estagiário Júnior
- Posts: 2
- Joined: Thu, 25 Feb 2010 8:47 am
- Location: Porto
Good morning,
Does anyone know how to change the name of the attached file?
Thank you for help, thank you!
Greetings,
Nuno Neves.
Does anyone know how to change the name of the attached file?
Thank you for help, thank you!
Greetings,
Nuno Neves.
-
- Rank: Estagiário Júnior
- Posts: 2
- Joined: Thu, 25 Feb 2010 8:47 am
- Location: Porto
Changing the name of the attached file when sending is via Reports Server.
Thanks! [/ U]
Thanks! [/ U]
-
- Information
-
Who is online
Users browsing this forum: No registered users and 22 guests