Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS 2005 page header/footer issues upon export to Excel Expand / Collapse
Posted Wednesday, May 8, 2013 8:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 10, 2016 11:16 AM
Points: 4, Visits: 32
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.
Post #1450626
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse