SSRS exports to Excel with tabs
Is it possible SSRS exports to Excel with many tabs layout?Minh
September 12th, 2011 4:26pm

Yes. If you provide page breaks after group, there would seperate tabs for each value in the group. In 2008 R2 version, you can even name the tabs based on the values in the group. Regards Manoj ~Mark as Answer if its helpful~
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2011 12:44pm

Hi MinhKng, Thanks for your question and Manoj’s reply. In SSRS, a new Excel worksheet tab is created for each explicitly defined logical page break. Different versions have different handing for this feature. For SSRS 2008 and before, if there is only one worksheet in the workbook, the name of the worksheet is the report name. If there are multiple worksheets in the workbook, the worksheets are named SheetX, where X is the number of the sheet in the workbook. Please refer to the section of Pagination in this article: Exporting to Microsoft Excel (Report Builder 2.0) For SSRS 2008 R2, we use the InitialPage property to specify a default name for the worksheet tab name when you export the report, and use page breaks and the PageName property to provide different names for each worksheet. Please refer to the section of Naming Excel Worksheet Tabs in this article: Understanding Pagination in Reporting Services (Report Builder 3.0 and SSRS) Hope it helps you. If you have any other questions, please let me know. Thanks, SharpPlease remember to mark the replies as answers if they help you and unmark them if they provide no help.
September 16th, 2011 3:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics