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
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Bar code implementation in reports?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

learntsql
Aged Yak Warrior

India
509 Posts

Posted - 08/01/2011 :  02:12:26  Show Profile  Reply with Quote
Hi All,

How to implememnt Barcode feature in SSRS?
Please guide me.
TIA

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 08/01/2011 :  04:29:08  Show Profile  Reply with Quote
you need to use code 39 font in ssrs for displaying barcode.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

learntsql
Aged Yak Warrior

India
509 Posts

Posted - 08/01/2011 :  04:57:37  Show Profile  Reply with Quote
Thanks Visakh16,

will it be read by bar coder?
could you Please explain bit more clear how to generate a sample barcode info in ssrs.
TIA.
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17440 Posts

Posted - 08/01/2011 :  05:12:42  Show Profile  Reply with Quote
this has actually nothing to do with SQL Server.

easiest way of printing barcode is to use a barcode font. Most of the barcode font are not free. One free font is code 39. Just google for it and you will be able to find it.

As Visakh suggested, use the code 39 font in the SSRS to display & print the barcode. For code 39, remember to pre & post fix it with asterix '*'

The barcode printed will be able to read by a barcode scanner as long as the printout of the barcode is good quality (use laser printer if possible).


KH
Time is always against us

Go to Top of Page

KeepDynamic
Starting Member

3 Posts

Posted - 05/12/2012 :  06:01:52  Show Profile  Reply with Quote
Intelligent Mail barcode generator control for SSRS:
http://www.keepdynamic.com/dotnet-barcode-reporting-service/usps-intelligent-mail.shtml
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 05/12/2012 :  20:58:23  Show Profile  Reply with Quote
why are you reopening old threads?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Barcode
Starting Member

11 Posts

Posted - 10/15/2012 :  00:02:33  Show Profile  Reply with Quote
Helpful!
quote:
Originally posted by KeepDynamic

Intelligent Mail barcode generator control for SSRS:
http://www.keepdynamic.com/dotnet-barcode-reporting-service/usps-intelligent-mail.shtml


unspammed
Go to Top of Page

Barcode
Starting Member

11 Posts

Posted - 11/21/2012 :  21:17:54  Show Profile  Reply with Quote
First, figure out what barcode you need to create, then choose winforms or ASP.NET to integrate with your ssrs reports. detailed steps below:

Install Barcode Generation Control/SDK for Reporting Services
Create New Reporting Services Project in Visual Studio
Add Item on Toolbox of Visual Studio, then drag and drop it to the barcode column.
Add a "Barcode" column to display the linear or 2D barcode images.
Drag and drop the "Winform.Linear" to the "Barcode" column of the report. Move to the "Properties" setting panel and change "BarcodeData" to "=Fields!AccountNumber.Value".
To view the report, you need to click the "Preview" button.

Details, you could refer to ssrs tutorial: http://www.aspper.com/barcode-reporting-services/tutorial.html

Hope this helpls.

barcode@www.aspper.com
Go to Top of Page

Thomassunshine
Starting Member

5 Posts

Posted - 02/21/2013 :  02:31:06  Show Profile  Reply with Quote
Here is a Barcode Generator for Reporting Service.
Befor install , you need Config Environments.
http://www.businessrefinery.com/products/barcode_reporting_service/main.html
Barcode Generator for Reporting Service provides flexible barcode size related options to resize generated barcode image via X, Y dimension, Barcode width & height, wide to narrow ratio, quiet margins of top, bottom, right and left, etc.
Hope it helps!
Go to Top of Page

abbyyy
Starting Member

9 Posts

Posted - 04/06/2013 :  23:45:57  Show Profile  Reply with Quote
To,generate barcodes in Microsoft SQL Server Reporting Service (SSRS) reports,you'd better confirm barcode type and the platform. Then you can refer to a user guide for barcode generation in SSRS.
Go to Top of Page

faith723
Starting Member

1 Posts

Posted - 08/08/2013 :  23:17:03  Show Profile  Reply with Quote
Did you use the tool from that site? I am intending to create QR Code in SSRS. But I see two barcode generators there support to do this. here are they:
http://www.onbarcode.com/products/net_barcode_reporting_service/2d_barcodes.html
http://www.onbarcode.com/products/net_barcode_reporting_service/barcodes/qrcode.html

Which one is better?
Go to Top of Page

cindy313
Starting Member

USA
7 Posts

Posted - 08/09/2013 :  04:03:51  Show Profile  Reply with Quote
quote:
Originally posted by abbyyy

To,generate barcodes in Microsoft SQL Server Reporting Service (SSRS) reports,you'd better confirm barcode type and the platform. Then you can refer to a user guide for barcode generation in SSRS.


yeah,and besides you may refer to this SQL Server Reporting Services (SSRS)http://www.keepautomation.com/guide/barcode_reporting_service.html
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000