Hello Microsoft or Forum Members: This seems like a simple Microsoft Based Reporting System 101 feature...But I can not find out how to do it (among other things that seem like it should work with Microsoft rendering to Microsoft). How do I make the SSRS 2005 Header for the Report print on each of the pages in excel once it is rendered from SSRS? All I want is an answer by MSFT that says "YES" it can be done and how or "No" it is not currently available. I noticed I am not the only one with this type of simple question: (see this unanswered post) http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1281464&SiteID=1 Thank You guys!

goodguy1974 wrote: "No" it is not currently available. I believe that would be the answer. It seems to me that the Excel export renders only the content of the report, not so much the layout of the page. A page rendered in an internet browser is not quite the same as a page rendered in excel.

Thank you... I wish you had a MSFT after your name so I could tell my boss that Microsoft says it can't be done with this version.... Still hoping... Thanks Again!

How many pages are your reports?

The reports range from 14-200 pages...

Hi, This answer comes a little too late for the person who asked the question, but since there are similar questions on the forums, I am posting it here for the community. Excel renderer has two different ways of rendering the header for each report page (worksheet) depending on the setting SimplePageHeaders from the DeviceInfo. This switch controlshow the header is rendered according with these rules: 1.when SimplePageHeaders =false, the header is rendered at the top of each worksheet cell grid, so as part of the report layout, andis visible on each worksheet in normal view mode. The header repeats at the top of each worksheet in the workbook except the document map. The presence of headeron the first page and on the last page can be controlled via the switches RepeatOnFirstPage and RepeatOnLastPage. 2.when SimplePageHeaders =true, the header is rendered as part of the native Excel worksheet header section and is visible only in print preview mode. However, because of Excelspecific functionality, this header is valid only at worksheet level, that means only for the physical pages that are printedfrom the same worksheet. According with these rules, in order to have the headers printed on all the pages of the Excel rendered report,I would suggest to use the option 1. Thank you, Mihaela

Thank You for the reply...Better late than never :-)

How do you set the device infomation properties?

Where do I find the DeviceInfo? I Googled this and was informed that its in the rsreportserver.config file but it doesn't exist in there.