Ever had someone ask you:�I have this Oracle Report that I need to email or print to file. I have to run this report multiple times with only one parameter changing. Isn’t there an easier way to perform this?�. Well there is and it is called Reports Bursting.
I came across this functionality when reviewing the Oracle Reports 9i new features and came to the conclusion it is kind of available since Oracle Reports 6. The improvement is that one is now able to burst on repeating data within the report.
Reports bursting offers you to deliver a single report to multiple destinations simultaneously. This functionality offers you to create multiple reports out of one single report model. The document Reports Bursting describes to you how to use the reports bursting functionality in Oracle Reports.
After playing around sometime with the bursting functionality of Oracle Reports I conclude that:
• Bursting your report offers you the possibility to run one report resulting in the creation of several reports.
• A fetch of the data is performed only once compared to running several times the same report with only one different input parameter.
• The formatting of the layout is performed only once.
Overall reports bursting is an elegant solution and worthwhile considering as an option for firing multiple times the same report with as only difference one input parameter.
Hi,
I found a program which is doing report bursting and it delivers the bursted documents through email and/or ftp. The tool is called DocumentBurster (www.pdfburst.com) and it is free for using. It can burst reports generated with any popular report generator like Bussiness Objets or JasperReports and it can be used on Windows and Unix systems.
Thank you,
Doru
Thanks Marcos, just what I needed 🙂 I knew it had to be possible!
Well it is not possible to use the 9i feature with the repeat property.
In reports 6 you can use the reports distribution frunctionality which allows you to use a .DST file to distribute the report to several distributions at once
Hope this helps
i am using oracle reports 6. how can i use the report bursting feature since it has no repeat on property on the property pallete? tnx.