SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Barcode rendering


Barcode rendering

Author
Message
paul.farnell
paul.farnell
Mr or Mrs. 500
Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)

Group: General Forum Members
Points: 596 Visits: 129
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
Neodynamic
Neodynamic
Mr or Mrs. 500
Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)

Group: General Forum Members
Points: 560 Visits: 227
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). 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

Tools for SSRS, ASP.NET & PHP
Barcode CRI for SSRS
paul.farnell
paul.farnell
Mr or Mrs. 500
Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)Mr or Mrs. 500 (596 reputation)

Group: General Forum Members
Points: 596 Visits: 129
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.
Neodynamic
Neodynamic
Mr or Mrs. 500
Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)Mr or Mrs. 500 (560 reputation)

Group: General Forum Members
Points: 560 Visits: 227
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

Tools for SSRS, ASP.NET & PHP
Barcode CRI for SSRS
cathyhill345
cathyhill345
SSC-Enthusiastic
SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)

Group: General Forum Members
Points: 108 Visits: 11
paul.farnell (3/3/2014)
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, when exporting barcode to a PDF 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
NYCnewbie
NYCnewbie
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 12
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search