How to Set Up Excel Bursting for SSRS Reports in RemiCrystal

In order to use remiCrystal's Excel Bursting feature, you must first modify your SSRS report to include a Bursting Field. This field will be used by remiCrystal to pick up any information that you would like to pass from the report to remiCrystal at run time. 

To add the Bursting Field to your SSRS report

1. Open your report in Report Builder
2. Right-click on your main dataset and select Add Calculated Field
3. Provide a name for the new field and then click on the fx button
4. 
5. Using the formula editor, create the formula to look similar to the below image
6. The formula must conform to the following rules
   1. must start with “{burst:true“
   2. must end with “}“
   3. all the field/value pairs must be pipe “|” delimited
   4. fields cannot contain the pipe “|” or colon “:” characters
7. Once completed, your calculated field must return a value that looks like 

   {burst:true|emailaddress:[e-mail]|project:Mesa Verde Bank Project|projectmanager:John Doe}

8. Hit OK to save the new field and then add to your group header as a text box
9. Make sure that your report is set to add a page break after every group as follows 
10. You may now save the report and publish it your SSRS server.

Now that your SSRS contains the required Bursting Field for every group, it is ready to be used in remiCrystal for Excel Bursting.

1. Open remiCrystal from the Windows Start Menu
2. Click on the Create Excel Bursting Task button
3. Provide a name and description for the task
4. Go to the Reports & Actions tab and click on the SSRS Report button 
5. Select the report you would like to use for Excel bursting and provide values for parameters if necessary
6. When you get to the Output Format tab, you will get this prompt 
7. Hit OK to have remiCrystal generate the report to read the Bursting Field that you created in the first part of this document
8. Once the report has been generated in the background, you can then select Excel Bursting Fields from the Function Picker to view all the available report fields
9. The available Excel Bursting fields can be used for the report name as well as all other areas such folder names, email addresses etc by simply dragging and dropping them into the fields
10. Hit Save to finish setting up the report
11. You may now finish setting up the task as normal. When executed, remiCrystal will split the report into single worksheets and deliver each one individually to your specified targets/destinations.