locked
SSRS Wingdings 2 checkboxes appear as R and £ on pdf RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1346512353 posted

    Hi I am using below expression in SQL Server Reports to assign value as check/ uncheck to boxes using font Wingdings 2. The problem is that on my local machine the pdf shows up correctly with checkboxes but on server the pdf is generated having "R" & "£". The server has the font installed already. Any idea what might be causing this?

    IIf(First(Fields!Complications.Value, "dsRoSDiabetic").ToString().Contains("Complex"), Chr(82), Chr(163))

    Thanks

    Thursday, May 7, 2015 2:44 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User1711366110 posted

    I am using below expression in SQL Server Reports to assign value as check/ uncheck to boxes using font Wingdings 2. The problem is that on my local machine the pdf shows up correctly with checkboxes but on server the pdf is generated having "R" & "£". The server has the font installed already

        As per my research of this case, This bug is related to PDF Renderer not SSRS. you may try it without font embedding as well and the characters are still not displayed correctly in Acrobat Reader. you can also try the Word PDF Exporter and the resulting PDF document displays the characters above 127 just fine. They actually wrote them out using Glyph IDs (CID font) even though the characters are in the ANSI range. you will have to do the same for the PDF Renderer.

    for more information, refer the similar scenarios which are faced in different forum threads :

    1.Refer here : Discussion about PDF export: characters above 127 not displaying for Wingdings in ssrs from MSDN forum

    2.Refer here : Discussion about SSRS Checkbox in Wingdings font when exported to pdf from MSDN forum

    3.Refer here : Discussion about Wingdings 2 checkboxes appear as R and £  from ASPOSE forum

    --
    with regards,
    Edwin

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 8, 2015 3:17 AM