Excel Export Column headers Reporting Services 2005 RRS feed

  • Question

  • I have a reporting service that has two rows of column information that I would like to see in the excel export.

    To be clear The report works fine in reporting services and if I did a web archieve.  It does not work in the excel export.
    The report would also work if I went into the export excel sheet and made the following modifications

    File Page Setup

    Sheet Tab

    Rows to repeat at top: from $1:$2 to $1:$4

    I cannot move the row into the column header section as it contains a Field with information that changes.
    The repeat report item with data region on every page is grayed out and checked.

    Thanks in advance for any help on this tricky problem.
    joe alt
    Tuesday, August 12, 2008 8:31 PM