Friday, August 31, 2018

SSRS - Export SSRS report into multiple excel sheets name

SSRS is the most amazing data visualisation tool which provides many amazing features. One of the best feature of this tools is to export data into multiple sheets in excel and provides Name the worksheets according to group value. We can assign dynamically sheet name / tab name. When SSRS report is exported into excel format then the report data will be divided into multiple sheets and each sheet must have Tablix Header.


To create multi tabbed report, we have to follow the following steps -
  1. Add Row Group to the report and choose Parent Group
  2. In Group Properties window, choose Page Break and checked Between each instance of a group
  3. In Row Group section, click on Group details and go to property window
  4. In property window, open expression window for PageName and assign the group name from the report dataset
  5. To fix tablix header in every new sheet/tab, Click on Advance mode form Row and Column Group and set true property of KeepTogether and RepeatOnNewPage
  6. Preview of the report ---- Done
For actual implementation, please watch the below video -




2 comments:

  1. Comfortabl y, the post is actually the freshest on this precious topic. I concur with your conclusions and also definitely will eagerly look forward to your future updates. Saying thanks definitely will not simply just be acceptable, for the fantastic lucidity in your writing. I definitely will instantly grab your rss feed to stay abreast of any updates. Fabulous work and also much success in your business endeavors! Help with Excel

    ReplyDelete
  2. How can I programmatically call the report and generate to excel using aspnet core.

    ReplyDelete

Popular Posts