SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Barcode?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

chriskhan2000
Aged Yak Warrior

USA
544 Posts

Posted - 03/30/2005 :  15:11:07  Show Profile
Anyone using barcode dll files before? I search and there seems to be only 1 out there, which is the IDAutomationBarcode which runs about $420. Anyone found a workaround or knows how to generate barcode at a cheaper price?

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 03/30/2005 :  15:47:10  Show Profile
You could check this out:
http://www.sqlservercentral.com/columnists/mivica/generatingabarcode.asp

rockmoose
Go to Top of Page

chriskhan2000
Aged Yak Warrior

USA
544 Posts

Posted - 03/30/2005 :  15:53:18  Show Profile
Thanks Moose. My boss wants everything in Reporting Services so I will need to figure out a way to get it to work in reporting services. We had used asp.net in the past to generate barcode, but I'm trying to figure if it's possible to specify the font type to barcode font and convert it that way. Doing some testing and will see if anything turns out.

From my understanding one can use barcode font by expressing the value like:

*I10022022*
Go to Top of Page

chriskhan2000
Aged Yak Warrior

USA
544 Posts

Posted - 03/30/2005 :  16:07:33  Show Profile
Got it to work as intended now. Downloaded barcode fonts and install those barcode fonts. Then I just apply that text box as the barcode font and presto it's in barcode format.

Only problem is that all users how use this must install the same barcode font on their machine or they will see a bunch of meaningless numbers.
Go to Top of Page

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 03/30/2005 :  16:14:55  Show Profile
Ok, sounds nice, that barcode font.
...making a mental note...

rockmoose
Go to Top of Page

ElQueso
Starting Member

4 Posts

Posted - 03/31/2005 :  17:59:52  Show Profile
To counter the problem with your users needing the font - maybe you could create an assembly that would create a grpahic of the font? The assembly could create a bitmap using the DrawString function to create the barcode, and then display the bitmap in the report instead of a textbox wit actual text.

Dunno, just a quickie off the top of my head.
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 03/31/2005 :  18:41:57  Show Profile  Visit Merkin's Homepage
quote:
Originally posted by ElQueso

To counter the problem with your users needing the font - maybe you could create an assembly that would create a grpahic of the font? The assembly could create a bitmap using the DrawString function to create the barcode, and then display the bitmap in the report instead of a textbox wit actual text.

Dunno, just a quickie off the top of my head.



I believe this is the way to do it, but it can be a bitch to get working. There are a few threads about this here, I know someone who spent a bunch of time getting it to work.


Damian
Ita erat quando hic adveni.
Go to Top of Page

chriskhan2000
Aged Yak Warrior

USA
544 Posts

Posted - 04/01/2005 :  16:09:34  Show Profile
It will be awesome to be able to do what you guys suggested, but if it's going to take several days to get it to work. I rather just install the fonts on whoever's machine that needs to view the barcodes.

Would be nice if someone can provide the dll file or some kind of example to follow.
Go to Top of Page

JustinBigelow
SQL Gigolo

USA
1157 Posts

Posted - 04/07/2005 :  13:27:18  Show Profile
I was able to get the barcode fonts rendering on the browser but they don't export to pdf (try it I dare ya). Since you can't scan from the browser it rendered (pun intended) RS completely useless for a particular aspect of the project. Instead I had to return to my mistress of pain, Crystal Reports.

"Hit me with a shovel 'cause I can't believe I dug you."
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 04/07/2005 :  13:30:04  Show Profile  Visit tkizer's Homepage
I've had issues with the export to pdf for other things as well. I was using the strike out option. Worked fine when viewing from html, but from pdf the strike out wasn't there. I tried all sorts of other things that would make sense to the user, but nothing worked. I ended up having to put brackets around the data, which was not intuitive to the user so we had to include information about this in our help docs.

I hope the pdf support for RS improves in the next version.

Tara
Go to Top of Page

JustinBigelow
SQL Gigolo

USA
1157 Posts

Posted - 04/07/2005 :  13:34:42  Show Profile
If I remember correctly the problem with the pdf export is that the font must be converted to an image to export to pdf. So ElQueso's solution of converting the font to a bitmap at render time should work.

"Hit me with a shovel 'cause I can't believe I dug you."
Go to Top of Page

chriskhan2000
Aged Yak Warrior

USA
544 Posts

Posted - 04/08/2005 :  17:55:48  Show Profile
Oh that sucks big time. We can export it to web archive and print from there, but it doesn't look as pretty any more. Only if they could put the damn print button feature. Hopefully they thought of this and put that on the next release.

I wonder when the next release will be due? Any ideas?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 04/08/2005 :  17:59:48  Show Profile  Visit tkizer's Homepage
I just heard this today: Reporting Services service pack 2 will include the option to print from html but it requires an ActiveX control on the client. And sp2 is due out this month.

Tara
Go to Top of Page

Gabriel
Starting Member

1 Posts

Posted - 04/22/2005 :  18:10:44  Show Profile
Here are step by step guides about how to add barcode images using .NET component without fonts!

Using Barcode Professional for ASP.NET in Reporting Services
http://www.neodynamic.com/ND/FaqsTipsTricks.aspx?tabid=66&prodid=1&sid=24

Using Barcode Professional for Windows Forms in Reporting Services
http://www.neodynamic.com/ND/FaqsTipsTricks.aspx?tabid=66&prodid=3&sid=25

Cheers
Go to Top of Page

chriskhan2000
Aged Yak Warrior

USA
544 Posts

Posted - 04/25/2005 :  09:49:14  Show Profile
This one you provided is cheaper than the one from IDMS, but it would be nice if I can use what we already have to work for us and not have to buy another new product. In the past we use barcode fonts to work with asp.net web pages. NOw that we are moving away from the old reports and into this new Reporting Services format, I was hoping that I can reuse what we already have.

Maybe the print option for RS 2 may allow printing of barcode if it supports direct printing?
Go to Top of Page

JustinBigelow
SQL Gigolo

USA
1157 Posts

Posted - 04/25/2005 :  12:20:01  Show Profile
quote:
Originally posted by Gabriel

Here are step by step guides about how to add barcode images using .NET component without fonts!

Using Barcode Professional for ASP.NET in Reporting Services
http://www.neodynamic.com/ND/FaqsTipsTricks.aspx?tabid=66&prodid=1&sid=24

Using Barcode Professional for Windows Forms in Reporting Services
http://www.neodynamic.com/ND/FaqsTipsTricks.aspx?tabid=66&prodid=3&sid=25

Cheers



I checked out the website and $199 for a dev license with a royalty free runtime isn't too bad. I'm going to download the eval, I'll post my results.

pst, Gabriel I'll trade you a glowing review for a free license j/k

"Hit me with a shovel 'cause I can't believe I dug you."
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 04/25/2005 :  19:17:07  Show Profile  Visit Merkin's Homepage
JB!

Welcome back from the dead



Damian
Ita erat quando hic adveni.
Go to Top of Page

hethanse
Starting Member

1 Posts

Posted - 10/10/2013 :  05:13:19  Show Profile
unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000