Is there a way that I can have a rdl file for report header and call that rdl to all my reports. If anything changes in the header rdl, all my reports gets updated. Template is not an option as it doesn't update the reports if anything changes and I read subreports have some print problems if we use. SSRS 2008 r2 Thanks so much

You might consider creating an image with an external or database source and placing that in your header. That way it will be centrall located and any changes will be rendered on all reports.Martina White

Hi Emma, I think, there are two possible ways: 1> As martin has suggested to create an image like that and throughout your reports 2> You can also create sub-reports and call that in all your reports as header. But, moreover i'll say these are not any good way to do. For your easiness to achieve this what i can say is: create a report template with header. Important: if possible you can place your header information in a database table and call it in reports. Even you can store image file, multimedia files etc in table. =================================== Rahul Vairagi ========================================== My Blogs: www.sqlserver2005forum.blogspot.com

Hi emma As Martine & Rahul said you can achive your result. -consider creating an image with an external or database source and placing that in your header -As martin has suggested to create an image like that and throughout your reports -You can also create sub-reports and call that in all your reports as header. Below thing you need know while Designing Reports with Page Headers and Footers for Specific Renderers. Working with Page Headers and Footers When defining page headers and footers for reports that target the Excel rendering extension, follow these guidelines to achieve best results: -Use page footers to display page numbers. -Use page headers to display images, titles, or other text. Do not put page numbers in the header. In Excel, page footers have a limited layout. If you define a report that includes complex report items in the page footer, the page footer won't process as you expect when the report is viewed in Excel. The Excel rendering extension can accommodate images and absolute positioning of simple or complex report items in the page header. A side effect of supporting a richer page header layout is reduced support for calculating page numbers in the header. In the Excel rendering extension, default settings cause page numbers to be calculated based on the number of worksheets. Depending on how you define the report, this might produce erroneous page numbers. For example, suppose you have a report that renders as a single large worksheet that prints on four pages. If you include page number information in the header, each printed page will show "Page 1 of 1" in the header. Suhas KudekarMark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful. My Blog Follow @SuhasKudekar