how would you accomplish that?

0 votes
asked Nov 17, 2015 in SSRS by Sunain (420 points)
You have report that has multiple pages with different group data, you want to render to excel but each group data should go to separate sheet, how would you accomplish that?

1 Answer

0 votes
answered Dec 14, 2015 by darsh (3,020 points)

Set the property "Pagebreak" on the tablix or table or other element to force a new tab, and then set the property "Pagename" on both the element before the pagebreak and the element after the pagebreak. These names will appear on the tabs when the report is exported to Excel.

More info u can find on this link
http://www.macaalay.com/2014/03/13/generate-multiple-worksheets-by-groups-in-ssrs-exported-excel-spreadsheets/

Welcome to I Can Crack, where you can ask questions and receive answers from other members of the community.

68 questions

47 answers

3 comments

5,318 users

...