Post reply

export to excel default to portrait

  • August 26, 2008 at 7:26 am

    #197486

    It seems like every report I do when I export it to excel the default setting for that excel worksheet is set to landscape.

    90% of the time that is what I want.

    What about the other 10%. Can you force the setting?

    My end users find it too "difficult" to change the setting from the printer properties.

  • August 26, 2008 at 1:18 pm

    #863352

    Read the very last entry in this thread.

    http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/ced46d3319ec0854

    [font="Comic Sans MS"]toolman[/font]
    [font="Arial Narrow"]Numbers 6:24-26[/font]

  • August 27, 2008 at 12:27 pm

    #863923

    LOL!

    Yes if you set the body of your report so the height is larger then the width it will change the format of your exported excel to portrait.

    Never would I have tried that.

    Kinda stinks cause now I have all this blank space in the layout. (No it doesn't show that space when you render the report)

    Thank you very much.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply