Exporting to excel

  • How do I get my report to filter data by tabs when it is exported to excel?

  • You would need to insert a page break in the report, that way when it renders to excel it will but what ever is between the page brakes in a new workbook.

  • How do I add the page breaks?

  • I found it here thanks http://technet.microsoft.com/en-us/library/dd207058(v=sql.105)

  • Now i am trying to get the tab name of each work sheet to display the name of the group for the page break. Any ideas?

  • SSRS 2005 doesn't appear to have a way to name excel worksheets.

    SSRS 2008 R2 can name Excel worksheets when a report is exported -- see Robert Bruckner's blog post:

    http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

  • Thanks. I found the way to name the worksheet tabs by setting the page break expression.

    The problem now is is the column headers do not show on each page although i have the tablix property for column headers to repeat across each page in report builder 3.0. Any ideas?

  • jdbrown239 (7/26/2012)


    Thanks. I found the way to name the worksheet tabs by setting the page break expression.

    The problem now is is the column headers do not show on each page although i have the tablix property for column headers to repeat across each page in report builder 3.0. Any ideas?

    Ran into that myself today - there's instructions here

    Not exactly obvious! 🙂

  • Thanks for the tip. When I changed the 'Repeat on each page' for the static column I got this error when I tried to preview the report.

    The tablix 'Tablix1' has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false.

  • Yeah, I did the same!

    It's actually the Row Group you need to set it on.

    Think the KeepWithGroup option needs to be set too for it to work.

  • Yes that was it!

    My last issue with columns repeating down the page.

    All columns repeat down the page that same as the results do when I run the report query in SSMS except for one column. For some reason this one column only displays once on the page and not for every row in the page.

    Any ideas?

  • Thanks for the help! It worked!

  • Just wanted to thank everyone for their help. I was able to render the report to excel with all the tabs and columns showing.

  • Thanks. I found the way to name the worksheet tabs by setting the page break expression.

    You actually dynamically set the tab labels in <2008R2? Might I ask how you did this?

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

Viewing 14 posts - 1 through 13 (of 13 total)

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