Friday, February 24, 2012

Export to Excel

Hi, i am trying to export report data to excel but when i choose to print,
its default layout is set to LANDSCAPE and i want to set the layout to
PORTRAIT. HOw can i do. If anybody has done it pls share it with me.
Thanks
JAsvinderJasvinder,
we found the same problem with PDF files.
The way around it, for us, was to simply create the form wide so it
defaulted to lscape. This cannot be the correct way it was intended, but
after reading through the help files, it was the only solution we found, and
it worked.
Tony
"Jasvinder" wrote:
> Hi, i am trying to export report data to excel but when i choose to print,
> its default layout is set to LANDSCAPE and i want to set the layout to
> PORTRAIT. HOw can i do. If anybody has done it pls share it with me.
> Thanks
> JAsvinder|||This is by design. Setting the page wider than it is tall is equivalent to
landscape.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Logicalman" <tony9scott45us@.com7cast.net34> wrote in message
news:919C4AA9-9EA4-4159-81E2-12402D9C763D@.microsoft.com...
> Jasvinder,
> we found the same problem with PDF files.
> The way around it, for us, was to simply create the form wide so it
> defaulted to lscape. This cannot be the correct way it was intended, but
> after reading through the help files, it was the only solution we found,
> and
> it worked.
> Tony
> "Jasvinder" wrote:
>> Hi, i am trying to export report data to excel but when i choose to
>> print,
>> its default layout is set to LANDSCAPE and i want to set the layout to
>> PORTRAIT. HOw can i do. If anybody has done it pls share it with me.
>> Thanks
>> JAsvinder|||Open you RS project in the BI studio and click on the Report properties.
Towards the bottom of the properties dialog there is an Interactive Settings
and Page Settings for width/height. The Page width/height is probably set to
11 - 8.5, change this to 8.5 - 11. Build and deploy your project and see if
this corrects your problem.
"Jasvinder" wrote:
> Hi, i am trying to export report data to excel but when i choose to print,
> its default layout is set to LANDSCAPE and i want to set the layout to
> PORTRAIT. HOw can i do. If anybody has done it pls share it with me.
> Thanks
> JAsvinder

No comments:

Post a Comment