Can we set page title while we export from SSRS2008 to Excel. In Detail I am having a report which will be exported only to excel. And this report will not fit to any page size. I am ok with that. But when I print I need report header (Which is row locked because simplepageheader is set to false) on each page. Can we set page title property of Excel from SSRS 2008. Any help is appreciated.

Hi Ram, By default, if we add a PageHeader in a report, and then after exported the report to Excel format, the PageHeader will be existed in the first row of the Excel file and each page will be repeated in print mode, but the Excel Page Header will not be set. From your description, do you mean that you can set the Excel Page Header after the report exported to the Excel format from the Report Manager? And in the print mode, the PageHeader of the report can be showed in each page? If so, we can specify rendering extension parameters in the RSReportServer.config file to override default report rendering behavior, change the device information setting to deal with this issue. Please refer to the steps below: 1. Please navigate to RSReportserver.config file: <drive:> Program Files\Microsoft SQL Server\MSSQL.<X>\Reporting Services\ReportServer\RSReportserver.config. 2. Please backup the RSReportserver.config file before you modify it, open the RSReportserver.config file with Notepad format. 3. Set the Excel rendering extension code like this: <Render> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"> <Configuration> <DeviceInfo> <SimplePageHeaders>True</SimplePageHeaders> </DeviceInfo> </Configuration> </Extension> </Render> 4. Save the RSReportserver.config file. Note: Changing the rendering extension parameters only affects rendering operations on the Report Server. For more information about customizing rendering extension parameters in RSReportServer.config, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms156281.aspx If I have misunderstood, please point out. Best Regards, Bin Long

HI Bing, Thanks for your response. I am not using report manager to export the report. I am processing reports using subscriptions. I don't want to set the page title after the report is exported to excel. I want set the page title property of Excel from SSRS 2008 while it is rendering. I am not using page header in report because It is matrix report and also cannot change the RSReportserver.Config for Excel because all other projects are using the same server. Having all this can we repeat the page title on each page while printing. Thanks, Ram