Exporting subreport to excel … SOS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Exporting subreport to excel … SOS

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.

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
This posting is provided AS IS with no rights for the sake of knowledge sharing.