Ssrs Export To Pdf Fit

Posted on

Symptoms

Consider the following scenario:

  1. After you run the report, you can export it to different file formats. For more information, see Export Reports (Report Builder and SSRS). Rendering Behaviors. Depending on the renderer you select, certain rules are applied when rendering the report. How report items fit together on a page is determined by the combination of these factors.
  2. Feb 01, 2012 Just by increasing the size of “Page Width” does not guarantee that exported page will fit into one page in PDF file. But it’s more like a trial-error method. So you have adjust is again and again till the page stop splitting into multiple pages. That means, you increase the size to 10in and test your SSRS Report by exporting to PDF.
  3. But, actually if you try to print the same report or save it to pdf you will realize that it is printing an extra page. This extra page can be at the end of the report (in this case, only one extra page is printed in total) or there could be one normal, one blank page, one normal and one blank page which has now doubled the amount of pages you.
  4. SSRS 2008 R2 Reports export to PDF to fit one page like Excel. SQL Server SQL Server Reporting Services, Power View. SQL Server Reporting Services. SSRS Report exported to PDF – Report page is split into multiple pages. Solution: In SSRS Report Layout, go to “Report” menu and select “Report Properties”. You will see dialog box as shown below.

By right clicking the report in SSRS we can get to Report Properties, which lets us edit the page size and margins for exporting to PDF and printing. Editing the Page Size can allow you to ensure your report is taking the most of the available space, by either having the size smaller than a typical page which will make the report display larger when printed, or having a larger size which will allow for more content to be displayed, but at a smaller size.

  • You have applied Cumulative Update 1 for SQL Server 2008 R2 Service Pack 1 (SP1) or a later updates installed on a computer whose locale is set to Japanese.

    Excel mac manual calculation

  • The Windows code page (ANSI code page) has half-width characters on the computer.

  • You export a report to PDF, and the selected font has a full-width version of the ± (plus-minus) character.


In this scenario, you may find one or more of following issues in the PDF file that is generated:

Ssrs Pdf Width

  • There are extra spaces after apostrophes.

  • Text before dollar signs overlaps the dollar signs.

  • Some special characters seem to cause spacing problems.


Note The issue also occurs in SQL Server 2012 and SQL Server 2014.

Fit

Cause

The issue occurs because of an incorrect Unicode change made since SQL Server 2008 R2 SP2 CU1.

Resolution

The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 4 for SQL Server 2014 /en-us/help/2999197

Cumulative Update 2 for SQL Server 2012 SP2 /en-us/help/2983175

Cumulative Update 11 for SQL Server 2008 R2 SP2 /en-us/help/2926028

About cumulative updates for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:



Note After you apply this cumulative update, you may experience the following issue: if the report server is on a system whose locale set to Japanese, and the ± (plus-minus character) is in a report being exported to PDF, some characters may overlap. To work around this issue, use one of the following methods:

  • Change to a font that uses a half-width '±' character.

  • Change the locale of the server that is running SQL Server 2008 R2 Reporting Services or SQL Server 2012 Reporting Services to English.


Options

Ssrs Export To Pdf Fit To Page

Status

Ssrs Export To Pdf Fit To Page

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the 'Applies to' section.