Search code examples
reporting-servicesssrs-2012

SSRS Export to PDF character spacing issues on Windows 2016 server

Using: SQL Server 2012 Reporting Services,
Product Version: 11.0.7462.6
Report Server Mode: Native

A server side rdl report is generated as PDF.

Sample rdl file contents here

On a Windows 2008 R2 Server, the generated PDF looks ok:

enter image description here

On a Windows 2016 Server, there are minor spacing issues with the PDF (see bits underlined in red):

enter image description here

i.e. for line "1", the spacing between the lower case "l" and number "2" is non-existent. The text value for line "1" looks like this: 

="Chos achrPapis Frhmistisya Sdt AFT hTe apetociaschmrdtP rilyus TtFam l25044025 - stuTr" & vbcrlf & "a"

Note that line "2" displays ok. Line 2's text value is the same as that for Line 1, but only has 1 line: 

="Chos achrPapis Frhmistisya Sdt AFT hTe apetociaschmrdtP rilyus TtFam l25044025 - stuTr"

So it seems having a carriage return is a factor in this problem.

Also, in line 3, there should be a space between "world" and "Support", but there isn't.

The problem only seems to be on export to PDF. The report looks fine when generated in Html, Word etc.

Can anyone shed any light?

EDIT: I should add that there are no special characters or anything like that being used in the report.

Solution

  • Moe,

    I can't confirm your issue. I deployed the report on SSRS 2016, and it looks fine to me. I'm using:

    SSRS: Microsoft SQL Server Reporting Services Version 13.0.4446.0

    SQL Server: Microsoft SQL Server 2016 (SP1-CU4) (KB4024305) - 13.0.4446.0 (X64) Jul 16 2017 18:08:49 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 6.3 (Build 14393: ) (Hypervisor)

    Maybe your CU is not the same as the one I'm using here, so I suggest updating SQL to the latest update.

    See the picture below:

    enter image description here