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

Batch Barcode and QR Scanning into Excel with Scan-IT to Office, Lightning-Fast!

-
Image
🚀 Get ready to revolutionize your barcode scanning game with an upcoming feature that's set to redefine efficiency in our #ScannerApp, Scan-IT to Office! 📲✨ 🌟 Curious about the buzz? Take a sneak peek into the future of barcode and QR code scanning by checking out our latest YouTube short. Brace yourselves for a game-changing experience as we introduce lightning-speed batch scanning! Scan-IT to Office isn't just your average mobile scanner app — it's a dynamic data acquisition app that seamlessly transfers real-time mobile-collected data to target systems. And guess what? We're about to kick it up a notch with the introduction of SUPERBATCH — the ultra-fast batch scanner mode (better terms are welcome, please comment). Say goodbye to the hassle of scanning one by one; with SUPERBATCH, effortlessly scan hundreds of codes directly into Microsoft Excel (or any other supported target system)! Our teaser video showcases the magic of SUPERBATCH in action. Picture scanned b...
Read more

Using KIA EV6's V2L Function to Safeguard Data Center During Power Outages

-
Image
Data Center Power Outage Resilience, a Real-World Scenario (be warned, this post is off-topic) Longer-lasting grid power outages can pose significant challenges to data centers. In this blog post, we share a real-world scenario where the V2L (Vehicle-to-Load) function of a KIA EV6 became a lifeline for our data center. Specifically, we'll delve into the steps taken to utilize the KIA EV6 to power the UPS (Uninterruptible Power Supply) of our data center during an outage caused by a planned power grid shutdown. The Challenge In this particular instance, our power grid operator scheduled a power shutdown in our area to perform major replacement and upgrade work, leaving the data center without its usual power supply for about two hours. To overcome this challenge, our team decided to leverage a KIA EV6, equipped with a 50-meter extension cable, to provide a continuous power source to the UPS, ensuring uninterrupted service to our IT infrastructure. 👉 Important: Our team tested the c...
Read more