SQL Server Performance

Exporting subreport to excel ... SOS

Discussion in 'SQL Server 2005 Reporting Services' started by rsnewbie, Oct 31, 2006.

  1. rsnewbie New Member

    Hi there

    I'm using VS2005 and SQL 2005 reporting services.

    I've got a main report and a subreport in one of the table cells. I'm using local processing mode for these.

    When the reports are viewed from the reportviewer, everything looks fine. But when I export it to Excel, the subreport isn't exporting. Instead I get the following message : "Subreports within table/matrix cells are ignored."

    How can this be addressed ? Is there anyway of getting information on the subreport exported to excel ? Any help would be greatly appreciated.

    TIA.
  2. satya Moderator

    From other site:

    Nested tables do not render within excel.
    Place the sub report in a list item


    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page