Cannot save the Page Setup to Landscape, or Export to PDF in Landscape

Question

Cannot save the Page Setup to Landscape, or Export to PDF in Landscape

SqlServerCampbell

Old Hand

Points: 384
More actions
July 18, 2023 at 5:03 pm

#4238418

When I change the Page Setup to Legal/Landscape and narrow margins (.25 each side), it runs ok.
But when I save the Report and Open it later, the page settings are back to the default Portrait/Letter and margins 1 everywhere.
And even when the right Page Settings are in effect, the exported PDF still looks like a Portrait setting with 1 inch margins.

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

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

ratbak Ten Centuries Points: 1333 More actions · Answer 1

I had to create separate extension definitions in rsreportserver.config to get those to work -- e.g.,

 <!-- <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/> -->
<Extension Name="PDF Landscape" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering">
<OverrideNames>
<Name Language="en-US">PDF Landscape</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputFormat>
<PageHeight>8.5in</PageHeight>
<PageWidth>11in</PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="PDF Portrait" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering">
<OverrideNames>
<Name Language="en-US">PDF Portrait</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputFormat>
<PageHeight>11in</PageHeight>
<PageWidth>8.5in</PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="PDF Legal- Landscape" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering">
<OverrideNames>
<Name Language="en-US">PDF Legal - Landscape Mode</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputFormat>
<PageHeight>8.5in</PageHeight>
<PageWidth>14in</PageWidth>
</DeviceInfo>
</Configuration>
</Extension>

Note: I didn't define margins, but I assume margins could be included.

SqlServerCampbell Old Hand Points: 384 More actions · Answer 2

Extension definitions. Ok thanks, I never heard of that before.

SqlServerCampbell Old Hand Points: 384 More actions · Answer 3

Hi ratbak,

It looks like the easiest solution is to right-click in the grey area outside the report body, select Report Properties, and change the Page Setup there.