Post reply

Can I export to Excel and force my headers into page headers in Excel?

  • October 19, 2010 at 4:38 am

    #225116

    This may require Javascript or something but is there some way of setting up my reports in SSRS 2005 so that when I export to Excel, my page headers go directly into the excel headers. I don't mean into the top few rows of the spreadsheet, I mean so that when you print preview, you can see them but when you're looking at the data, they're not there.

  • October 29, 2010 at 7:41 am

    #1244187

    it's probably not possible out-of-the-box, so you should look into building your own rendering extension for this, or maybe you can find a third-party rendering extension that suits your needs.

    If you have to build it yourself, I think it would be easier to render to excel 2007-2010 format, as that is essentially a zipped set of xml-files, whereas excel 1997-2003 is a binary format.

    Peter Rijs
    BI Consultant, The Netherlands

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

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