hellou thanks a lot for answer. footer is in rdlc. rdlc is included in link above. Generaly footer is exported but is not showed when open excel file but must go into View - and page align. In this case but file is not showed properly, is not look good.
:D
According to your description, you want to export data from ReportViewer to Excel with footer.
Firstly, please try to use the Crystal Reports to achieve the fuction.
And here is a code snippet for you to refer to:
ReportDocument RDObject = new ReportDocument();
//loading the report
RDObject.Load(Server.MapPath("Employee Saler.rpt"));
//passing the parameter to report
RDObject.SetParamaterValue("Employee ID", "AFTRD");
ExportOptions exop = new ExportOptions();
//setting the format to excel type
ExcelFormatOptions excel = ExportOptions.CreateExcelFormatOptions();
exop.ExportFormatType = ExportFormatType.Excel;
exop.ExportFormatOptions = excel;
//enabling the headers and footers for each page
excel.ExportPageHeadersAndFooters = (ExportPageAreaKind.OnEachPage);
CrystalReportViewer1.ReportSource = RDObject;
//exporting the report
RDObject.ExportToHttpResponse(exop, Response, true, "");
More information please try to refer to the link:
# Crystal Reports Excel Export Issue – page footer not being displayed
Secondly, please try to use the header to replace the footer. As you can control where you want your header to be shown when exported to excel by using the Excel device settings in rsreportserver.config available in Program Files\Microsoft SQL Server\MSSQL.X\Reporting
Services\ReportServer folder. The name of the setting is SimplePageHeaders and by default its value is false which means that header will be the first row when exported to excel. If it is set to true, it will again not be shown in the normal
view.
More information, please try to refer to the link:
thanks a lot, now we are using reportviewer 2010 bcz is free and simple for user. For reportviewer 2010 have somebody any opinion? We have created many reports for reportviewer and all must be changed when will using crystal report.
None
0 Points
4 Posts
ReportViewer doesn't export footer to Excel
Sep 02, 2013 01:48 AM|Vajda65|LINK
I have a problem with exporting to Excel. In an RDLC file, I have a body and a footer. After exporting to Excel, the footer is not showing properly.
http://www.sendspace.com/file/bevi1i
The link above is the RDLC file, exported Excel and exported PDF. In the PDF, everything is ok and looks good.
Is there a known solution to this problem?
</div>Contributor
2535 Points
842 Posts
Re: ReportViewer doesn't export footer to Excel
Sep 03, 2013 06:44 AM|umairaslam22|LINK
I dint saw your attachment.
IF the footer is html footer below report , it wont be included in excel file.
But if the footer is in rdlc report it will be exported.
If you wrote the footer in html include it in rdlc report in design mode apply that style.
MCP
Blog
Please remember to Mark as answer if any post help you , it help others to find right solution in less time
None
0 Points
4 Posts
Re: ReportViewer doesn't export footer to Excel
Sep 03, 2013 08:20 AM|Vajda65|LINK
hellou thanks a lot for answer. footer is in rdlc. rdlc is included in link above. Generaly footer is exported but is not showed when open excel file but must go into View - and page align. In this case but file is not showed properly, is not look good. :D
Contributor
3997 Points
432 Posts
Re: ReportViewer doesn't export footer to Excel
Sep 03, 2013 08:53 AM|Lisa Zhang - MSFT|LINK
Hi,
According to your description, you want to export data from ReportViewer to Excel with footer.
Firstly, please try to use the Crystal Reports to achieve the fuction.
And here is a code snippet for you to refer to:
ReportDocument RDObject = new ReportDocument(); //loading the report RDObject.Load(Server.MapPath("Employee Saler.rpt")); //passing the parameter to report RDObject.SetParamaterValue("Employee ID", "AFTRD"); ExportOptions exop = new ExportOptions(); //setting the format to excel type ExcelFormatOptions excel = ExportOptions.CreateExcelFormatOptions(); exop.ExportFormatType = ExportFormatType.Excel; exop.ExportFormatOptions = excel; //enabling the headers and footers for each page excel.ExportPageHeadersAndFooters = (ExportPageAreaKind.OnEachPage); CrystalReportViewer1.ReportSource = RDObject; //exporting the report RDObject.ExportToHttpResponse(exop, Response, true, "");More information please try to refer to the link:
# Crystal Reports Excel Export Issue – page footer not being displayed
http://scn.sap.com/thread/932121
Secondly, please try to use the header to replace the footer. As you can control where you want your header to be shown when exported to excel by using the Excel device settings in rsreportserver.config available in Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer folder. The name of the setting is SimplePageHeaders and by default its value is false which means that header will be the first row when exported to excel. If it is set to true, it will again not be shown in the normal view.
More information, please try to refer to the link:
# Footer does not exported to excel
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/244ff1a0-c4c8-4980-8893-bc0fdda7dcc2/footer-does-not-exported-to-excel
Best Regards,
Lisa Zhang
None
0 Points
4 Posts
Re: ReportViewer doesn't export footer to Excel
Sep 03, 2013 09:02 AM|Vajda65|LINK
thanks a lot, now we are using reportviewer 2010 bcz is free and simple for user. For reportviewer 2010 have somebody any opinion? We have created many reports for reportviewer and all must be changed when will using crystal report.
None
0 Points
4 Posts
Re: ReportViewer doesn't export footer to Excel
Sep 09, 2013 01:43 PM|Vajda65|LINK
nobody have solution for reportvieweR?