Hi Scott,

Can you let us know your exact requirement.  Like, Do you want to burst and distribute entire output file as a single file OR want to generate multiple files based on some key value? what is your delivery method? i.e. Email or FTP? Based on these details, we can provide you a sample bursting query.

Thanks,

UIma

Hi Scott,

Hope this helps

Q What is Bursting ?

A Bursting is a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations

Below is a step by step use case to explain the process

Steps 1. Create a Data Model with a bursting Query

a. Create a Data Set

================================

Data Source : ApplicationDB_FSCM

Use the sample Query

Select * from DOO_HEADERS_ALL
where STATUS_CODE = 'OPEN'
AND rownum<4

Aim : The output of this query is three rows with three different order number . Our Aim is to split this in to three reports containing Single Order in each  Hence we selected KEY as ORDER NUMBER

b. Create a Bursting Query

==================================

Select ORDER_NUMBER  AS "KEY",  -- It must be same as deliver by
'Test.rtf' TEMPLATE, -- Fusion Report template name--
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT,
'EMAIL'  DEL_CHANNEL,
'abc@email.com' PARAMETER1,  -- to mail address   (use a valid Email Address)---
'geh@email.com' PARAMETER2, -- cc email address (use a valid Email Address)--
'sggf@email.com'  PARAMETER3,----From Email Address(use a valid Email Address)---
'Your Order Details' PARAMETER4,-- Email Subject--
'Please find attached your Order Details' PARAMETER5,-- Email body --
'true' PARAMETER6,--Attachment value ('true' or 'false'). If your output format is PDF, you must set this parameter to "true" to attach the PDF to the e-mail.
'tgfgg@email.com' PARAMETER7-- reply-to mail address(use a valid Email Address)---

from DOO_HEADERS_ALL
where STATUS_CODE = 'OPEN'

AND rownum<4

c. Save the data Model and export the XML

Step 2 : Create a RTF template with the help of the XML exported . Create a Report based on this RTF Template (Test.rtf)

Step 3: Edit the Report > Go to Properties (Right hand side of the page) > Check Enable Bursting under Advanced

Step 4: Schedule the Report and you will receive three mails in your mail as per the given bursting query

NOTE : Use the same format as suggested in the Bursting query for correct result