Excel does not honor page settings

Rendering in Excel does not honor my page layouts (landscape, 8.5x14, etc.) -
every report comes out 8.5x11 portrait. PDF works fine, as does printing
from the HTML default. Any input is appreciated.
ScottI 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
"ScottB" wrote:
> Rendering in Excel does not honor my page layouts (landscape, 8.5x14, etc.) -
> every report comes out 8.5x11 portrait. PDF works fine, as does printing
> from the HTML default. Any input is appreciated.
> Scott|||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....
Milu wrote:
> 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
> "ScottB" wrote:
> > Rendering in Excel does not honor my page layouts (landscape, 8.5x14, etc.) -
> > every report comes out 8.5x11 portrait. PDF works fine, as does printing
> > from the HTML default. Any input is appreciated.
> >
> > Scott|||I have the same issue. Any word on whether this is a setting issue or a bug?
"Milu" wrote:
> 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
> "ScottB" wrote:
> > Rendering in Excel does not honor my page layouts (landscape, 8.5x14, etc.) -
> > every report comes out 8.5x11 portrait. PDF works fine, as does printing
> > from the HTML default. Any input is appreciated.
> >
> > Scott

Every other page is blank after i set my report properties to landscape 11 x 8.5

Please does any one know what is causing my report's every other page to be blank.

i made the changes to the report properties layout width = 11, ht = 8.5

the report looks good in landscape but everyother page is blank.

Please help thank you very much for the info.

I personally found that changing the page margins to 0 on top/bottom/left/right worked to fix that issue.

Duane|||Maybe you need to make sure that your report elements fit within the margins of your page. Whats probably happening is that it's not really a blank page just some report element that didn't quite fit forcing a page break. So if the contents is just a little too wide it will print a seemingly blank page. Setting your margins to 0 kind of gets around this issue meaning your report body must fit within the report size as there are no margins.