SSRS 2005 page header/footer issues upon export to Excel

• fiachra.obraoin

  SSC Enthusiast

  Points: 182

  More actions

  May 8, 2013 at 8:54 am

  #293614

  I'm having an issue with a SSRS 2005 project where the structure of the master RDL is

  Page Header

  Sub-RDL 1

  Sub-RDL 2

  Page Footer

  The issue I'm having is with the header and footer. The header consists of several text-boxes contained in a rectangle. The footer is a page number indicator.

  The sub-RDLs both consist of several rectangles, each rectangle has a page break.

  When the report is exported to Excel the Page Header is OK for the first page of the report but then goes wonky. The interesting thing is when it moves onto the 2nd sub-RDL it returns to normal. This behaviour is regardless of which sub-RDL is put second, different order same result. The normal header is the first in the below image, followed by the wonky one which becomes stretched.

  

  In addition if I remove the Page Footer the header behaves normally throughout the report, so I thought it was something to do with the Interactive Size of the report but setting this to 0cm, 0cm has not yielded any breakthrough.

  Any help is appreciated, thanks.