SQL Server Home
Bar Code does not Print in SSRS
as By Design
1/19/2009 6:15:24 AM
User(s) can reproduce this bug
A bar code font used on an SQL Server 2008 SSRS report renders in IE as intended, but when printed from the same desktop the bar code font is changed to clear text - presumably the default font. On other XP desktops where the font is installed, using either IE 6 or IE 7, the same behavior is exhibited.
Server properties: "Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2) "
The report was developed in Visual Studio 2008 v9.0.30729.1 SP, .Net v 3.5 SP1, on Vista SP1, all patches applied.
Bar code used is IDAutomationHC39M, a TTF.
When the web page is copied to Word (click in the report, Ctrl-A, Ctrl-C, switch to Word, Ctrl-V), the page is correctly printed.
When the font is used by itself in a test web page, it prints correctly.
The font is converted to human readable text when the report is exported to PDF, but remains as a bar code when exported to either Word or Excel.
The printer driver has been configured to print fonts as graphics.
SQL Server 2008 - Standard Edition
Windows Vista SP1
Operating System Language
Steps to Reproduce
Generate and print an SSRS report in IE that uses a bar code font.
Printed report bar code font converts to human readable font.
printed report retains bar code.
to post a comment.
Please enter a comment.
on 3/29/2013 at 1:25 AM
It is easy to use a barcode DLL in SSRS report to generate and print barcode like the one,
on 2/8/2012 at 7:17 AM
this is a SSRS barcode encoding sdk, which is capable of encoding Code39, Code128, UPC, EAN, QR Code, PDF417, Data Matrix barcodes in SQL reporting services.
on 6/9/2011 at 6:46 AM
Very good work!! Thank you. Your reboot recommendation worked for myself as well. YAY! It would seem the Fonts are cached & installing the font doesnt re-initialize the cache in RS.
Hey Microsoft, you have a mechanism to recognize that a font is in use so that it cannot be removed while in use, but you dont have the converse of that same situation in updating caches for which new fonts are installed. Tisk tisk* (Rant over)
Thanks again Corey, U R A life saver.
on 4/16/2009 at 5:23 PM
Hi, sorry for the delayed response. I'm glad to hear it's working now. We've noticed that the operating system requires that the server be rebooted before newly installed fonts will work properly.
The reason that IE and printing from the report server work differently is because the server is using different API calls to load fonts when it generates the image for printing than IE does on the client.
on 1/21/2009 at 4:57 AM
Why was this resolved before I verified the resolution steps you had outlined?
I believe this issue still clearly represents a bug - please consider reopening it.
on 1/21/2009 at 4:54 AM
I did verify that the font is installed on the SSRS server, but it had not been rebooted, and as a production box, I can't until the weekend. However, I did restart the SSRS service, and behold it now works. Yay!
Evidently, SSRS caches the list of fonts installed on the server at the time the service starts. This is sort of counter-intuitive, as printing happens down on the client, not on the server.
My issue is resolved, but this still seems to be a bug in the report viewer control and/or printing mechanism. My problem occurred by clicking the Print link in the viewer, which replaced the custom font with a default one, however when I clicked _IE's_ print button, the custom font came through on the print job. It would seem there's a needless dependency in there somewhere.
on 1/20/2009 at 4:30 PM
Based on the description of the problem, it sounds like the font may not be installed on the Report Server. Can you please make sure the font is installed on the server, and then reboot the server? Also, in the latest cumulative update for SQL Server 2008 font embedding functionality was added to PDF.
on 1/20/2009 at 6:51 AM
More information found during testing:
- I can view on screen any used-added font, but none will print.
- If I run the report by debugging it in Visual Studio (by pressing F5), I can view and print any font.
This behavior is seen on several computers - Vista, XP, Windows 2003.
on 1/19/2009 at 2:08 PM
Two attachments added, a PDF and a DOC, both exported from the same report.
on 1/19/2009 at 1:24 PM
Can you please attach a copy of a PDF generated from SSRS that exhibits this behavior?
SQL Server Reporting Services
to post a workaround.
Please enter a workaround.
© 2014 Microsoft