when export report to excel from vb.net code; header is missing. I tried with bleow code also is not working <DeviceInfo> <SimplePageHeaders>True</SimplePageHeaders> </DeviceInfo> in the report viewer; device info paramter. In output excel; I enable the view -> page layout; header titile is coming; images and others are hinding.

See if this helps you http://dimantdatabasesolutions.blogspot.com/2009/02/how-to-render-report-to-pdfexcel-format.htmlBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

I have used Report viewer as well as webservice which is highlighted by above post. Both are same result header is missing....

i am using SSIS script task; i could not import Microsoft.SqlServer.ReportingServices2005 namespace; can you let me know. Note: my code also PDF is working fine. problem in the excel export

hi MVP, ???

Hi David, The SimplePageHeaders setting indicates whether the page header of the report is rendered to the Excel page header. A value of false indicates that the page header is rendered to the first row of the worksheet. The default value is false. From you description, the header is missing in Excel might be caused that the SimplePageHeaders in Report Server configuration file is set to True. Therefore, we need overwrite this setting by passing the following device info to the Render method. <DeviceInfo> <SimplePageHeaders>False</SimplePageHeaders> </DeviceInfo> For more information about Excel Device Information Settings, please refer to http://msdn.microsoft.com/en-us/library/ms155069.aspx About the ServerReport.Render Method, please refer to http://msdn.microsoft.com/en-us/library/ms252210.aspx Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Change the simplepage header is to false. <DeviceInfo> <SimplePageHeaders>False</SimplePageHeaders> </DeviceInfo>Mark as Answer If appropriate - SSS.Ezhil