Post reply

Exporting to excel

  • July 23, 2012 at 2:56 pm

    #392809

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

  • July 24, 2012 at 3:16 am

    #1516668

    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.

  • July 25, 2012 at 7:29 am

    #1517332

    How do I add the page breaks?

  • July 25, 2012 at 7:33 am

    #1517337

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

  • July 25, 2012 at 3:04 pm

    #1517641

    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?

  • July 26, 2012 at 7:23 am

    #1517925

    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

  • July 26, 2012 at 7:58 am

    #1517950

    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?

  • July 27, 2012 at 10:36 am

    #1518639

    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! 🙂

  • July 30, 2012 at 7:50 am

    #1519147

    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.

  • August 1, 2012 at 10:56 am

    #1520406

    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.

  • August 2, 2012 at 9:55 am

    #1520970

    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?

  • August 3, 2012 at 8:05 am

    #1521412

    Thanks for the help! It worked!

  • August 16, 2012 at 7:40 am

    #1526579

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

  • August 17, 2012 at 6:19 pm

    #1527285

    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