Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

I have around 6+ years of experience in SQL Server development and in Business Intelligence area. I am working as Datawarehouse developer. My blog space includes all technical areas related to SQL Server and MSBI (SSIS, SSRS and SSAS).
Browse by Tags · View All
xml 3
dynamic 3
Union All 3
Data flow task 2
Buffer 2
Time 2
Date 2
varchar(max) 1

Archive · View All
February 2013 3
September 2009 3
June 2013 2
January 2013 2
November 2012 2
July 2012 2
July 2009 2
April 2013 1
December 2012 1
February 2010 1

Dynamic Page Breaks in SQL Server Reporting Services

Jul 26 2012 12:00AM by Divya Agrawal Shah   

I came around a report, where i need to export the report to Excel in such a way that when it gets exported every Group comes on a different sheet dynamically with the corresponding Group name. This requirement seems difficult at first, however its pretty easy to achieve it.

Let's take an example to demonstrate this situation. I have a student table, same as in my earlier blog.

I have created a sample report in SSRS where the dataset is the student table, as shown below:


As you can see in the picture above, that I have taken a tablix, with Gender as the Parent Group and below that Class as a Child Group. Here, I want Gender group to be displayed as two separate sheets in Excel with first sheet name as ‘Female’ and second sheet name as ‘Male’. This should be dynamic behavior.


Now our first step is to bring the distinct rows of the Gender group to different sheets of Excel document. To achieve this, open the Group Properties for Gender Group, and go to Page Breaks section, as shown below:



Our next step will be to give Group names to the sheets in excel. To achieve this, select the properties for Gender group Tablix member. Select Gender group and Press F4, to open the properties explorer. In that expand the Group property and set appropriate column name for PageName property as shown below:



Go to Preview and save the report in Excel format. When you will open the excel report, you can see the different sheets created with Gender values, as shown below:



See, how easy its now in SQL Server Reporting Services 2008 to give dynamic names to the sheets in Excel.

Please let me know your feedback on this post.

Tags: SSRS, dynamic, page break, excel, export, sheets

Divya Agrawal Shah
89 · 2% · 629



  • This comment is waiting for moderation.

    commented on Feb 18 2015 12:50PM
    2915 · 0% · 3
  • This comment is waiting for moderation.

    commented on Feb 18 2015 12:58PM
    2915 · 0% · 3

Your Comment

Sign Up or Login to post a comment.

"Dynamic Page Breaks in SQL Server Reporting Services" rated 5 out of 5 by 5 readers
Dynamic Page Breaks in SQL Server Reporting Services , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]