Last post Sep 09, 2013 01:43 PM by Vajda65
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.
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?
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.
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.
Sep 03, 2013 08:53 AM|Lisa Zhang - MSFT|LINK
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
//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
More information, please try to refer to the link:
# Footer does not exported 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.
Sep 09, 2013 01:43 PM|Vajda65|LINK
nobody have solution for reportvieweR?