Reporting Services into Excel

  • In a reporting services report that is exported into Excel, I have set up groups and there is a page break after each group. I'd like to change the automatic "Sheet 1", "Sheet 2" etc names into meaningful names (ie the Category used to make the group. How do I do that?

  • Hi Wendy,

    I too have had this problem in my organization and as a resolution we purchased and use the OfficeWriter product from SoftArtisans. It allows you to create custom Excel formatting for reports and is then available through an additional delivery extension that shows up. You can find information on their website found here: http://officewriter.softartisans.com/[/url]

    Hope this helps!

    Cheers,

    Ben


    Cheers,

    Ben Sullins
    bensullins.com
    Beer is my primary key...

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

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