sql server reporting services: Excel does not honor page settings -- sql server reporting services

RE: Excel does not honor page settings

Milu
3/27/2006 8:31:02 PM

I have got a similar problem.. report is set for portrait format but it comes
out Landscape in Excel. If you have found any solution, please do let me know.

Thanks,
Milin

[quoted text, click to view]

Re: Excel does not honor page settings

AMasson
3/28/2006 6:23:46 AM

I've had similar issues with Excel exports - it appears to use the
ratio of body height to body width to decide on orientation, not the
report page sizes. Only workaround I've used to force a portrait
orientation is to make the body height slightly larger than the body
width which appears to have the desired effect.

I've now got the opposite problem, I want the report to be landscape
and have the width set to 29.7cm, but because of the number of tables I
have in the report, the body height is greater than the width and it is
portrait when exported to Excel. Only way I can think of getting round
this is to put the tables into separate sub-reports, but I haven't had
time to try it out yet.....

[quoted text, click to view]

RE: Excel does not honor page settings

pbriggsiberia
4/5/2006 9:43:02 AM

I have the same issue. Any word on whether this is a setting issue or a bug?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.