Bar code implementation in reports? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Bar code implementation in reports?

Author

Topic

learntsql

524 Posts

Posted - 2011-08-01 : 02:12:26

Hi All,

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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-01 : 04:29:08

you need to use code 39 font in ssrs for displaying barcode.

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

learntsql

524 Posts

Posted - 2011-08-01 : 04:57:37

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.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-08-01 : 05:12:42

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
[spoiler]Time is always against us[/spoiler]

KeepDynamic
Starting Member

3 Posts

Posted - 2012-05-12 : 06:01:52

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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-12 : 20:58:23

why are you reopening old threads?

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

Barcode
Starting Member

11 Posts

Posted - 2012-10-15 : 00:02:33

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

Barcode
Starting Member

11 Posts

Posted - 2012-11-21 : 21:17:54

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

Thomassunshine
Starting Member

5 Posts

Posted - 2013-02-21 : 02:31:06

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!

abbyyy
Starting Member

9 Posts

Posted - 2013-04-06 : 23:45:57

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.

faith723
Starting Member

1 Post

Posted - 2013-08-08 : 23:17:03

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?

cindy313
Starting Member

7 Posts

Posted - 2013-08-09 : 04:03:51

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

derek054
Starting Member

1 Post

Posted - 2014-06-04 : 03:58:18

To create barcodes in ssrs, here's a guide for you.[url]http://www.businessrefinery.com/barcode-generate/csharp_barcode_generator.html[/url]

Be it or beat it!

learntsql

524 Posts

Posted - 2014-06-17 : 00:09:09

Thank you all for the usefull replies.

millera
Starting Member

1 Post

Posted - 2014-10-09 : 22:40:25

quote:
Originally posted by learntsql

Hi All,

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

Use ASP.NET Barcode Generator to generate barcode in your SSRS, or use .NET Barcode Generator for SSRS directly.

micagordon
Starting Member

6 Posts

Posted - 2015-04-28 : 02:47:33

You can get help from .net bar code generator for SSRS(reporting service), and this is the tutorial about how to generate bar code in SSRS.
Hope it can help you and others.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources