|JReport Tech Tip:
In a large enterprise reporting deployment, it is important to handle both large amounts of data as well as a large number of users. Report bursting enables running a report once and distributing the report results to multiple recipients who each will receive a subset of the report results. For example, a report like a monthly credit card bill is based on the same layout and database query but needs to show only the data for a particular customer.
Design a Bursting Report in JReport Designer
To design a bursting report, you will need to configure the bursting rules using the bursting dialog in JReport Designer.
1.1 Design a report and then click Report > Bursting on the menu bar to display the Bursting dialog.
Dataset: Specifies the dataset used in the bursting report.
Bursting Key: Specifies the database columns in the Bursting dataset which match the groups in the report used to split the report.
Data Source: Specifies the data source that contains the recipient query.
Query: Specifies the query from the selected data source which retrieves recipient addresses.
Recipient Mapping Identifier: Specifies a unique recipient column to map to each bursting key column.
Recipient: Defines the formats of recipient addresses
These fields define the columns which contain the E-mail addresses, FTP locations and disk locations for each user, group or role used to burst the report.
1.2 In the Mapping panel, create the mapping relationship between the bursting key and the recipient.
1.3 Save the report and publish the report set containing the bursting report to JReport Enterprise Server.
Scheduling a Bursting Report in JReport Server
2.1 In JReport Server, select the report set containing the bursting report, and click on the Schedule button.
2.2 In the schedule's Publish page, the corresponding tabs as specified in report bursting schema's recipient in JReport Designer will be shown such as To E-Mail.
2.3 After submitting a bursting task, the user can view the current running status and completed status.