Post reply

changed tabsheet labels in excel to match group by

  • May 4, 2006 at 2:17 pm

    #169262

    I've got a SS2000 Report that has a group by clause and Page Break at End is set so that each group will export to a separate worksheet when exporting to Excel.  Question is, I want the Excel worksheet tabs to display the grouped name. For instance, if i'm grouping by state then each state will have it's own worksheet.  I would like the tabs to display AL, AR, AZ....

    Any ideas

  • May 8, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • May 11, 2006 at 7:04 am

    #637223

    Just as an update, everything I've found said that it couldn't be done.  I scraped the Reporting Services report and used the excel program interop assembly and coded the project in C#.  It was a little more work but the results were exactly what we were after.

    And it was fun

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

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