Post reply

SSRS Export to Excel in different excel files

  • December 7, 2011 at 3:28 pm

    #264425

    Hi everyone is there a way where you can split t a large excel file into smaller excel sheets while exporting. Thanks

  • December 7, 2011 at 4:33 pm

    #1418422

    FYI - SSRS questions should probably be posted in the Reporting Services forums.

    If you mean that you want to split the report results onto separate worksheets within one excel workbook:

    With SSRS 2008 R2, use the PageBreak and PageName properties for your tables or groups to split into tabs with tab names defined. Prior to R2, you can use the page breaks to split the report into tabs, but cannot control the naming of the tabs.

    http://msdn.microsoft.com/en-us/library/dd255278.aspx

    see section: Page Breaks and Page Names

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply