SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS 2005 page header/footer issues upon export to Excel


SSRS 2005 page header/footer issues upon export to Excel

Author
Message
fiachra.obraoin
fiachra.obraoin
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search