Export to PDF and print in landscape

Hello

I have a report which I can print on legal paper, once I choose the landscape settings on print menu. When the same report is set to export to a file share in pdf format, it renders in portrait format. Is it possible to have the pdf document look like the landscape view so that the user can just hit print.

Thanks

Inder

No,

you would probably have to setup two reports, one in landscape and one in portrait.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hello

Thanks for the answer, but how do I set up the report in landscape or for that matter portrait?

|||

HI,

In the report designer, click on the small square in the top left hand corner of the page so you can view the page properties. Now set the page size in the properties box to 29.7 width and 21 height.

I can get screenshots if you need them?

Export to Excel Legal Landscape

I created a Landscape Report for Legal Paper. When I export the report to
Excel the report appears in Excel as Landscape for 8.5X11.
Does anyone know how I can resolve this issue?Have you tried changing the report page size to 8.5x14?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"sturmill" <sturmill@.discussions.microsoft.com> wrote in message
news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
>I created a Landscape Report for Legal Paper. When I export the report to
> Excel the report appears in Excel as Landscape for 8.5X11.
> Does anyone know how I can resolve this issue?|||Are you refering to the page size in the print dialog box for excel or the
page size in the report server. I have changed the page size in the report
server to 8.5 x 14.
Same results. Exports landscape to excel but size 8.5X11.
"Jeff A. Stucker" wrote:
> Have you tried changing the report page size to 8.5x14?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
> >I created a Landscape Report for Legal Paper. When I export the report to
> > Excel the report appears in Excel as Landscape for 8.5X11.
> >
> > Does anyone know how I can resolve this issue?
>
>|||Report server. Does it export to PDF or TIFF legal size correctly? Just
curious...
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"sturmill" <sturmill@.discussions.microsoft.com> wrote in message
news:D879AC34-A597-409F-9493-BAACB0489FEE@.microsoft.com...
> Are you refering to the page size in the print dialog box for excel or the
> page size in the report server. I have changed the page size in the report
> server to 8.5 x 14.
> Same results. Exports landscape to excel but size 8.5X11.
>
> "Jeff A. Stucker" wrote:
>> Have you tried changing the report page size to 8.5x14?
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
>> news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
>> >I created a Landscape Report for Legal Paper. When I export the report
>> >to
>> > Excel the report appears in Excel as Landscape for 8.5X11.
>> >
>> > Does anyone know how I can resolve this issue?
>>|||If I go into print setup in PDF it works and TIFF works. I have gone into
Print Setup for excel and set to legal and it still doesn't work. Any other
thoughts?
"Jeff A. Stucker" wrote:
> Report server. Does it export to PDF or TIFF legal size correctly? Just
> curious...
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> news:D879AC34-A597-409F-9493-BAACB0489FEE@.microsoft.com...
> > Are you refering to the page size in the print dialog box for excel or the
> > page size in the report server. I have changed the page size in the report
> > server to 8.5 x 14.
> > Same results. Exports landscape to excel but size 8.5X11.
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> Have you tried changing the report page size to 8.5x14?
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> >> news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
> >> >I created a Landscape Report for Legal Paper. When I export the report
> >> >to
> >> > Excel the report appears in Excel as Landscape for 8.5X11.
> >> >
> >> > Does anyone know how I can resolve this issue?
> >>
> >>
> >>
>
>|||I am still having this issue. Is this something that will be fixed in the
next service pack? My CFO's and CEO's are getting fustrated having to do
multiple steps to print the exported document in Legal Landscape.
"sturmill" wrote:
> If I go into print setup in PDF it works and TIFF works. I have gone into
> Print Setup for excel and set to legal and it still doesn't work. Any other
> thoughts?
> "Jeff A. Stucker" wrote:
> > Report server. Does it export to PDF or TIFF legal size correctly? Just
> > curious...
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> > news:D879AC34-A597-409F-9493-BAACB0489FEE@.microsoft.com...
> > > Are you refering to the page size in the print dialog box for excel or the
> > > page size in the report server. I have changed the page size in the report
> > > server to 8.5 x 14.
> > > Same results. Exports landscape to excel but size 8.5X11.
> > >
> > >
> > > "Jeff A. Stucker" wrote:
> > >
> > >> Have you tried changing the report page size to 8.5x14?
> > >>
> > >> --
> > >> Cheers,
> > >>
> > >> '(' Jeff A. Stucker
> > >> \
> > >>
> > >> Business Intelligence
> > >> www.criadvantage.com
> > >> ---
> > >> "sturmill" <sturmill@.discussions.microsoft.com> wrote in message
> > >> news:164F62F5-44A5-4A89-9132-D647DC10D538@.microsoft.com...
> > >> >I created a Landscape Report for Legal Paper. When I export the report
> > >> >to
> > >> > Excel the report appears in Excel as Landscape for 8.5X11.
> > >> >
> > >> > Does anyone know how I can resolve this issue?
> > >>
> > >>
> > >>
> >
> >
> >

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