Unable To Export Sub-report Data In Excel Format????
-
Hi all, I am using 'Report Viewer Control ' in my project. I am using sub-reports in many cases. Whenever I export such reports containing sub-reports to 'Excel' format which is the major client requirement in our project, the exported excel file shows 'Subreports within table/matrix cells are ignored.' Can anybody tell me the solution for this? If not possible in reporting service then is there any other way to get data in excel format? Thanks.
-
Hi all, I am using 'Report Viewer Control ' in my project. I am using sub-reports in many cases. Whenever I export such reports containing sub-reports to 'Excel' format which is the major client requirement in our project, the exported excel file shows 'Subreports within table/matrix cells are ignored.' Can anybody tell me the solution for this? If not possible in reporting service then is there any other way to get data in excel format? Thanks.
Use ExcelRecord instead in Excel. i.e. ExportFormatType.ExcelRecord for eg: ReportDocument.ExportToHttpResponse(ExportFormatType.ExcelRecord, Response, true, "Report");
-
Hi all, I am using 'Report Viewer Control ' in my project. I am using sub-reports in many cases. Whenever I export such reports containing sub-reports to 'Excel' format which is the major client requirement in our project, the exported excel file shows 'Subreports within table/matrix cells are ignored.' Can anybody tell me the solution for this? If not possible in reporting service then is there any other way to get data in excel format? Thanks.
Till SSRS 2005: This is a known limitation in the excel rendering. The problem occurs when subreports and/or any data regions are nested in table/matrix. Microsoft I mean SSRS doesn’t support exporting these to Excel format. Other way to get it done is: Embed the sub report within a rectangle rather than within a table. It will export ok. P.S.: SSRS 2008 (shipped as part of SQL Server 2008) provides a full solution to this, since it has a new engine and rendering extensions. Excel rendering will now always render subreports contents.
-
Till SSRS 2005: This is a known limitation in the excel rendering. The problem occurs when subreports and/or any data regions are nested in table/matrix. Microsoft I mean SSRS doesn’t support exporting these to Excel format. Other way to get it done is: Embed the sub report within a rectangle rather than within a table. It will export ok. P.S.: SSRS 2008 (shipped as part of SQL Server 2008) provides a full solution to this, since it has a new engine and rendering extensions. Excel rendering will now always render subreports contents.
Thanks for reply, ok iam placing the sub report into list control instead of Table then it works am i right? but in sub report Data is populating inside Matrix control then is it ok ?????/? Regards
-
Thanks for reply, ok iam placing the sub report into list control instead of Table then it works am i right? but in sub report Data is populating inside Matrix control then is it ok ?????/? Regards
Yes it should work. In SSRS 2005, subreports embedded in tables does not export properly in excel.