Till Date successful in Distributing from report Builder
1. Define distribution in report properties. It can also be defined at Header,Main or Footer
section of report
2. Desname= [Link]@[Link],alert@[Link]
3. [Link] file, add mail server settings [Link]:25
Not able to distribute reports from url using distribution defined in the Reports properties
[Link]
1g&server=rep_wls_reports_s08r71adf2&co=02&to_code=0200001&from_code=0200179&distribut
e=yes
Not able to distribute reports using [Link] file
[Link]
1g&server=rep_wls_reports_s08r71adf2&co=02&to_code=0200001&from_code=0200179&destinat
ion=anurag_sample.xml&distribute=yes
In reports 12.2.1 there is a bug in report distribution and needs to be patched
Link: Distribution Fails With REP-34304 Error in Oracle Reports 12c (Doc
ID 2110440.1)
[Link]
40.1&_afrWindowMode=0&_adf.ctrl-state=9ohzhhppd_45
[Link]
wls_reports_s08r71adf2&co=02&to_code=0200179&from_code=0200001&destination=anurag_sa
[Link]&distribute=yes
[Link]
wls_reports_s08r71adf2&co=02&to_code=0200179&from_code=0200001&destination=anurag_sa
[Link]&distribute=yes
anurag_sample.xml-------------------------------------------------------
<destinations>
<mail id="a5" from="alert@[Link]" to="[Link]@[Link]" subject="Distribution
Example">
<body srcType="text">Attached you will find the summary report and breakdown by department of
weekly totals.
</body>
<attach format="pdf" name="[Link]" srcType="report">
<include src="report"/>
</attach>
</mail>
</destinations>
anurag_sample1.xml----------------------------------------------------------
<destinations>
<mail id="a5" from="alert@[Link]" to="[Link]@[Link]"
subject="Quarterly Report">
<body srcType="report" format="html">
<include src="report"/>
</body>
</mail>
</destinations>
Report Bursting based on the Dept No
<destinations>
<foreach>
<mail id="ex2" to="[Link]@[Link]" from="alert@[Link]"
subject="This mail contains the files for &<F_SUPPLIER_GROUP>">
<body srcType="text">
This is the body of the message.
</body>
<attach format="pdf" name="report_&F_SUPPLIER_GROUP;.pdf"
srcType="report" instance="this">
<include src="mainSection"/>
</attach>
</mail>
</foreach>
</destinations>
[Link]
wls_reports_s67adf1&co=55&supplier_group=ALL&from_supplier=ALL&AS_ON_DATE=15/05/19&D
1=15&D2=30&D3=45&P_MSMED_TYPE=ALL&destination=anurag_sample_b.xml&distribute=yes
[Link]
test&server=rep_wls_reports_s67adf1&destination=anurag_sample_b.xml&distribute=yes
<destinations>
<foreach>
<mail id="ex2"
to="&<recipient>"
from="alert@[Link]"
subject="This mail contains the files for &<deptno>">
<body srcType="text">
This is the body of the message.
</body>
<attach format="pdf" name="report_&<deptno>.pdf"
srcType="report" instance="this">
<include src="mainSection"/>
</attach>
</mail>
</foreach>
</destinations>
[Link]
wls_reports_s67adf1&co=02&to_code=0200179&from_code=0200001&destination=anurag_sample
_b.xml&distribute=yes
