Zebra Plastic Card Printers.

Zebra Plastic Card Printers come in a variety of styles and price ranges, including single-sided printers, dual sided printers, and security printers

Healthy Solutions for Healthcare.

The healthcare industry benefits from barcoding. Barcoding enhances patient safety and operational efficiency.

Seagull Scientific Products

Seagull Scientific BarTender is an industry-leading label design and barcode software. Seagull Scientific also develops true Windows printer drivers for bar code and thermal printers.

MC 9190G

The Ability To Satisfy Your Company Software Requirements.

Wireless Broadband

The unrivalled Motorola portfolio of Point-to-Point (PTP), Point-to-Multipoint (PMP), and Mesh Wide Area Network (MWAN), WLAN and VoWLAN solutions make governments, enterprises, and service providers more agile by helping them deploy voice, video, and data applications right where they need them.

Showing posts with label MS SQL Reporting Service. Show all posts
Showing posts with label MS SQL Reporting Service. Show all posts

Friday, 9 April 2010

Printing Barcodes with SQL Reporting Services: TBarCode .NET

TEC-IT published a PDF document which outlines the usage of TBarCode SDK as barcode generator for SQL reporting services.


The .NET barcode class which is contained in the TBarCode SDK can be integrated seamlessly into MS SQL reporting services. Just a few lines of .NET code are needed to enhance a report with full bar code printing services for linear barcodes, 2D codes and GS1 DataBar symbologies.


Check out the document Printing Barcodes with MS SQL Reporting Services. A sample report including source code is available in the download section of TBarCode (Microsoft Visual Studio required).



Wednesday, 11 November 2009

Barcode Generator for SQL Reporting Service

To generate bar codes (ALL barcodes - meaning linear barcodes, 2D barcodes like DataMatrix and GS1 DataBar codes) all you need is an internet connection. Advantage: no additional software is needed and no Visual Studio is required. The basic idea is to insert an barcode image generated by the online barcode generator of TEC-IT. This barcode generator is customizable via the URL - so it is possible to create each bar-code as required.

1) Create the required barcode using the online barcode generator
2) Scroll down to the section "Free Use of This Barcode Generator". Copy the URL (see screenshot below) into your clipboard:

Barcodegenerator

3) Start the MS SQL Server Report Builder
4) Create a new report
5) Insert a Picture object and change the “Image Source” property to “External” (see screenshot below)

ImageProperties
6) Click on the “fx” button to set the URL for the barcode image (see screenshot below)

ImageURLFunction
Function used in the example above:
=”http://www.tec-it.com/online-demos/tbarcode/barcode.aspx?code=Code128&data=” & CStr(Fields!UserName.Value) & "&dpi=96&rotation=0&modulewidth=fit"

This creates an Code128 barcode using our online barcode generator. The data encoded in the barcode is stored in the UserName field:
CStr(Fields!UserName.Value)

7) Close all dialogs with OK

That’s all you need to do to insert barcode functionality to the Microsoft SQL Reporting Service.

Result

Interested?

If you like this method for barcode creation you can use the online barcode generator for free (for non-commercial use only). For commercial users TEC-IT recommends a local barcode server in the companies intranet.