Different Header and Footer Problem When Exporting to Ms Word From SSRS 2008 R2

• Teee-SQL

  SSCrazy

  Points: 2218

  More actions

  September 7, 2012 at 2:55 am

  #267366

  Hi All,

  I need to display different headers and footer in different pages. I have loaded the header and footer as embedded images using the expressions below:

  The header on the remaining pages needs to be blank(but it leaves a huge white space currently) and the footer needs to be a different image

  Headers:

  =IIF(Globals!PageNumber = 1 , "LetterHead_FirstPage_New","")

  Footer:

  =IIF(Globals!PageNumber = 1 , "LetterFooter_FirstPage_New", "LetterFooter_RemainingPages_New")

  This is displayed correctly in reporting services and works well when I export to PDF but when I export to word its ignored I can only see the headers displayed on the first page in all pages.

  How do I export the different header and footer to Ms Wod.

  Thanks in advance 🙂