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?
> > >>
> > >>
> > >>
> >
> >
> >