add a bar code font in a report to avoid installing it on every client ?
-
Hello,
I'm in SSRS 2005 and I would like if someone had an idea to add a font (barcode) in a report to avoid any install on customers, according to my research I saw that too we could develop its own Report Item (CRI).
-
Gianluca Sartori (9/10/2009)
I would not install fonts to display barcodes, I'd rather build the barcode image with some software and store the picture in a binary column.You could use barbecue[/url], for instance.
Hope this helps
Gianluca
Thank you for your answer, but I wanted to tell you that I am. Net, and I needed an implementable solution with Visual Studio 2005.
Thank you
-
Try this:
http://dotnetslackers.com/articles/net/BarcodeImageGenerationMadeEasy.aspx
1st Google result for "barcode .net image", btw.
-- Gianluca Sartori
-
Gianluca Sartori (9/10/2009)
Try this:http://dotnetslackers.com/articles/net/BarcodeImageGenerationMadeEasy.aspx
1st Google result for "barcode .net image", btw.
My problem is not in fact generate a bar code and even less in a web application c #.
I have a report. Rdl in which I use a special font for bar code, so that it works properly it is all the client installs the font.
I want a solution to avoid this.
I try to create a Custom Report Item, but I did not find good documentation.
thank you in advance
-
That's what I suggested: read the article I linked.
It explains how to create an image using the barcode font. Once you have the picture, you can save it to a table and use it in the report: no fonts to install to the clients.
-- Gianluca Sartori
-
Gianluca Sartori (9/11/2009)
That's what I suggested: read the article I linked.It explains how to create an image using the barcode font. Once you have the picture, you can save it to a table and use it in the report: no fonts to install to the clients.
I understand your solution, it would tell me to do a treatment to generate an image, stored in SQL Server and then load the report display, though of course there is a control that can do that natively.
In fact do you think I can generate the image cache (without saving it anywhere) and display on the report?
-
I had to do the exact same thing you're doing and I had no chance other than storing to the DB.
One way to avoid this would be linking an image as URL in the report, then change the URL adding the barcode as a parameter depending on data. The URL could be a link to a ASP.NET webapp that creates barcode images on the fly.
This was my first approach, but Crystal Reports didn't support dynamic URLs as image source. I'm not a SSRS expert, but maybe there's a way to achieve this.
-- Gianluca Sartori
-
Gianluca Sartori (9/11/2009)
I had to do the exact same thing you're doing and I had no chance other than storing to the DB.One way to avoid this would be linking an image as URL in the report, then change the URL adding the barcode as a parameter depending on data. The URL could be a link to a ASP.NET webapp that creates barcode images on the fly.
This was my first approach, but Crystal Reports didn't support dynamic URLs as image source. I'm not a SSRS expert, but maybe there's a way to achieve this.
Thank you very much for your help and your advice, I'll try to look more and if I find a better solution I'll post.
-
it doesn't get much easier than what Gianluca showed you:
i took that code, threw it on a web server, but had to hunt down the bar code font:
in my case, i just let the aspx page make the file, feed it to the http, then delete it locally again. no big deal
the code is nothing more than an image tab with this code:
https://www.sqlservercentral/Forums/Uploads/Images/786383-1.png
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
so if you had a report, and say you wanted to barcode some invoice number, right, you would just add an IMG tag and build the SRC dynamically;
the font i found on the internet is not all that clear, i might hunt for one that was a little crisper, but it works.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
I'm betting it's not so much the font itself that is unclear, as is the image saving process (which might be skewing/stretching the images to accomodate a specific size).
You may want to play around and come up with the best way to 1. not undersize the barcode, and 2. not change its native proportions during the save process. Either one will rather quickly drop the reliability factor of your barcode (it's useful only if a barcode scanner can actually scan that damned thing after all).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply