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.

Comments

Post a Comment

No spam please, comments are moderated.

Thanks, TEC-IT

Popular posts from this blog

"Tag it Easy" - vCard and MeCard QR-Codes!

-
Image
A new version of the barcode creator software Barcode Studio is on the way! What’s New? Barcode Studio V11.5 introduces a new data input assistant . This special feature simplifies the creation of 2D codes for mobile tagging and electronic business cards (so-called vCard and meCard barcodes) dramatically. With Barcode Studio V11.5 you are able to create more than 100 different linear, postal, GS1 and 2D barcode symbologies. The barcodes can be printed on simple labels or exported as bitmap or vector image files. Batch barcode creation with external data is supported. 2D Codes for Mobile Tagging vCard Data Input Assistant vCard and meCard QR-codes are used to encode contact details of a business card (like name, address, email, phone-number ...) in a 2D barcode symbol. When scanning such a barcode with a smartphone (camera and suitable scanner software is required of course), the data is automatically entered into the address book of the phone. No manual typing or copy/paste i
Read more

Scan-IT to Office - NEW VERSION

-
Image
The Smart Data Acquisition Solution Scan-IT to Office is a capable alternative to conventional mobile data collection devices and wireless barcode scanners. The app transmits mobile collected data in real-time to target applications - completely independent of their location. The collected data is immediately available for further processing. Scan-IT to Office  combines simple configuration with flexibility and covers an entire range of functions: from plain barcode scanning up to tracking and inventory applications with database connectivity . What's New? This update offers the following features: Inventory and Asset Management Added ready-to-use forms for inventory/stocktaking with automated quantity management (Microsoft SQL Server, Microsoft Excel, Google Sheets). Check-In/Check-Out Added ready-to-use forms for attendee tracking and check-in/check-out (Microsoft SQL Server, Microsoft Excel, Google Sheets). Bi-Directional Communication Added the capability to send data from a
Read more