March 3, 2014 at 10:06 am
Hi
I have developed a report with a code 3 of 9 barcode in it. The font has been installed on the SSRS server. The report displays perfectly on the screen but when printing adds some space into the middle of the barcode. Exporting to Word works fine, to a PDF it just shows the text not the barcode font.
Any ideas ?
Paul
March 4, 2014 at 4:31 am
Hi Paul,
Font issues is well known in SSRS when exporting to PDF format. The main thing to check out is that the font must be installed at each client machine where the PDF report will be opened. Anyway, IMHO, fonts are not suitable for real world barcoding scenarios (we've outlined some points here[/url]). At that page you can find a barcode tool that works in SSRS and does not use fonts for rendering the barcode or if you prefer to go on your own path, then you could grab this code, wrap it inside a .NET DLL, use it in your reports in a VB function and then call it from an Image control. In any of these cases, the barcode is generated as an image and you avoid installing anything on the client. Let me know if you have any further questions. Regards,
LeoZ
Support Team
March 4, 2014 at 4:39 am
Thanks for the reply. Despite numerous service restarts, making sure the font was on the PC's in question, a full reboot of the SQL/SSRS server has fixed the issue.
March 4, 2014 at 4:49 am
That's great! A last suggestion... print and try decoding the barcode with a real scanner device (use different brands & models if possible) to make sure that the barcode is read & decoded correctly. In addition, Code 39 in "standard mode" just encodes uppercase letter, digits + a couple of other chars. If you going to encode lowercase letters or any other non-printable char (ASCII 0 - 127), then Code 39 needs to be changed to "Extended mode a.k.a. Full-ASCII mode". If that is the case, then ensure the scanner is also configured to read full ascii Code 39 barcodes referring to the user manual. HTH,
LeoZ
Support Team
March 11, 2014 at 8:07 pm
paul.farnell (3/3/2014)
HiI have developed a report with a
code 3 of 9 barcode[/url] in it. The font has been installed on the SSRS server. The report displays perfectly on the screen but when printing adds some space into the middle of the barcode. Exporting to Word works fine, when exporting barcode to a PDF[/url] it just shows the text not the barcode font.Any ideas ?
Paul
Similar problem has been posted by a SQL Server 2008 SSRS report user at following link. He solved his problem by "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."
Maybe you can have a check.:-)
http://connect.microsoft.com/SQLServer/feedback/details/401908/bar-code-does-not-print-in-ssrs
October 20, 2015 at 1:12 am
paul.farnell (3/3/2014)
HiI have developed a report with a
code 3 of 9 barcode in it. The font has been installed on the SSRS server. The report displays perfectly on the screen but when printing adds some space into the middle of the barcode[/url]. Exporting to Word works fine, to a PDF it just shows the text not the barcode font.Any ideas ?
Paul
Hi, Paul.
Have you worked it out? I wonder what is the latest version of the Barcode Scanner which you were using? I am also looking for a fine barcode scanner whose way of processing is simple and fast to help me scan aztec barcode. It will be better if it offers free trials for users to check. Any suggestion will be appreciated. Thanks in advance.
Best regards,
Pan
October 20, 2015 at 1:13 am
paul.farnell (3/3/2014)
HiI have developed a report with a
code 3 of 9 barcode in it. The font has been installed on the SSRS server. The report displays perfectly on the screen but when printing adds some space into the middle of the barcode[/url]. Exporting to Word works fine, to a PDF it just shows the text not the barcode font.Any ideas ?
Paul
Hi, Paul.
Have you worked it out? I wonder what is the latest version of the Barcode Scanner which you were using? I am also looking for a fine barcode scanner whose way of processing is simple and fast to help me scan aztec barcode. It will be better if it offers free trials for users to check. Any suggestion will be appreciated. Thanks in advance.
Best regards,
Pan
October 20, 2015 at 1:15 am
paul.farnell (3/3/2014)
HiI have developed a report with a
code 3 of 9 barcode in it. The font has been installed on the SSRS server. The report displays perfectly on the screen but when printing adds some space into the middle of the barcode[/url]. Exporting to Word works fine, to a PDF it just shows the text not the barcode font.Any ideas ?
Paul
Hi, Paul.
Have you worked it out? I wonder what is the latest version of the Barcode Scanner which you were using? I am also looking for a fine barcode scanner whose way of processing is simple and fast to help me scan aztec barcode. It will be better if it offers free trials for users to check. Any suggestion will be appreciated. Thanks in advance.
Best regards,
Pan
February 23, 2018 at 10:22 am
My issue is similar to a point. I'm developing reports in SSRS 2010 that will be embedded in a mobile app. On my desktop I've installed the font 3of9 and it appears fine. When I export to PDF (the format that the users will see when they access the report), it looks fine. However, because this is a mobile app and my users are all over the place with many different versions of the root application (Android, IOS and Windows) as well as remote printers, there's no way I can get these fonts installed universally. In addition, a binary of the PDF will be exported to another business all together. So I'm looking to see if there's a way to embed the barcode font as an image of some type in my report, or any better solution (custom code?) that you may have. However, I cannot purchase anything, so don't bother sending links to alternate products.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply