WebFOCUS Online Help > ReportCaster End User > Creating and Maintaining a Distribution List > Bursting a Report
In this section: |
Instead of distributing an entire report, you can use the ReportCaster burst feature to break a report into sections to be distributed separately. Bursting enables you to target relevant sections of a report to individual users. Each report section is saved as a separate file.
If you are distributing a burst tabular report, the burst value is determined by the first BY field. If you are distributing a burst graph report, the burst value is determined by the second BY field. The burst value is automatically determined by the internal matrix, which is a memory area that stores each database field value and calculates values referenced by the TABLE or GRAPH request.
You can send several report sections to one recipient by specifying that recipient's destination (e‑mail address or printer) for each section you want to send. You can send several report sections to one destination or you can send one report section to several destinations. The burst values you specify in the Distribution List must exist in the data source you are reporting against.
Note: If you want to burst a report, you must select the burst option when you create the schedule for the report. The burst values specified in the Burst Value column in the Distribution List pane are ignored unless the schedule specifies to burst the report. For details on setting the burst option, see Report Information if you are using the Scheduling Wizard or Report Options if you are using the single page Scheduling Tool.
You can specify sort field Burst Values and Destinations (e-mail addresses or printers) when creating or editing a Distribution List. The following image shows burst values and e-mail addresses specified in the Distribution List pane.
Using the primary sort field values (Northeast, Southeast, and Southwest), each representative's e-mail address is associated with the relevant sales report data. Since Adam Abernathy needs only the data for the Northeast branch, the sort value Northeast is listed in the Burst Value column opposite his e-mail address in the Destination column.
However, Chuck Hill works in both the Northeast and Southeast regions. Since he requires data for both regions, his e-mail address is listed in the Distribution column twice, with a Burst Value column entry for each region opposite his e-mail address.
Tip: You can specify multiple e-mail addresses on a single Address line. For details, see Specifying Multiple E-mail Addresses.
This section provides detailed information to assist you in defining burst values.
When a report is burst, all data values generated for each burst section are returned to the ReportCaster Distribution Server.
The following are guidelines and limitations that apply to the ReportCaster burst feature:
[wildcard]:abc* = all values that start with ‘abc’.
[wildcard]:a?c = all three-character values that start with ‘a’ and end with ‘c’.
[wildcard]:a?c* = all values that start with ‘a’ and have a ‘c’ as the third character.
[regexp]:[bcr]at = values that are bat, cat, or rat.
[regexp]:[^bcr]at = any value that is not bat, cat, or rat.
[elsesend] = reports for burst values not contained in the Distribution List will be sent to the named recipient.
The following are example entries in an e‑mail distribution list that illustrate the use of the wildcard and default distribution keywords in burst values.
|
Burst Value |
Address |
|---|---|
|
[wildcard]:*an* |
sml@company.com |
|
England |
ray@company.com |
|
[elsesend]: |
jt@company.com |
Using a scenario where the report is burst on the Country field that contains values of Germany, USA, France, Canada, Italy, Chile, England, and Japan, then:
ON primarysortfield SUBHEAD
Note: For additional considerations when using WebFOCUS commands with burst reports, see Using WebFOCUS Commands With Burst Reports.
| WebFOCUS |