remiWare

Report Scheduler for Crystal Reports, SSRS Reports and more.

  • Features
  • Download
  • Pricing
    • Renew Maintenance
  • Version History
  • Contact Us/Support
  • Become a Partner
  • Blog

What Is Excel Bursting for SQL Server Reporting Services

August 16, 2019 by remiware

Lets say you have a single report that shows all your product departments and their corresponding managers. When the report is exported to Excel, every product department is placed in a separate worksheet (tab) and the tabs are named after the respective product manager. See the image below for illustration.

excel bursting for Sql Server reporting services SSRS can run much faster than native data-driven subscriptions in remicrystal

What if you wanted each Excel tab to be emailed separately to its corresponding manager while only running the report once?

remiCrystal Build 5045 has added a new feature called Excel Bursting. This feature is very similar to the existing PDF Bursting functionality that has been available in the software for a while.

Excel Bursting for SSRS reports allows you to split a single Excel Report so that each worksheet is placed into a separate file and then delivered to its corresponding recipient (in this case, the product manager).

Unlike SSRS’s native data-driven subscriptions where the report would need to be for each manager, Excel bursting is done by running the report only once!

Setting up Excel Bursting is achieved by simply adding a special Bursting Field to the SSRS report during design time and then getting remiCrystal read the field’s values at runtime.

To get started with Excel Bursting for SSRS Reports, take a look at this How-To article and then download remiCrystal for a free 14-day unlimited trial.

DOWNLOAD NOW

Filed Under: Uncategorized

 remiCrystal is Reliable

remiCrystal utilizes the Windows Task Scheduling system for all its automation. This means that your reports will be delivered as long as Windows is running. No ifs or buts.

 remiCrystal is Easy To Use

With remiCrystal, you do not have to spend money on training your staff on how to use the software. We believe that if you can use MS Word, then you can use remiCrystal.

 remiCrystal is Cost-Effective

When you purchase remiCrystal, you will begin to realize the return on investment immediately. You will save time money and human resources. Automating your processes will reduce errors in your reporting immensely.

COPYRIGHT ©REMIWARE 2018