Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Generate two-dimensional QR Code® bar codes in an SSRS report Expand / Collapse
Author
Message
Posted Tuesday, January 14, 2014 12:03 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 9, 2014 8:47 AM
Points: 128, Visits: 918
Comments posted to this topic are about the item Generate two-dimensional QR Code® bar codes in an SSRS report
Post #1530556
Posted Tuesday, January 14, 2014 2:10 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:18 AM
Points: 162, Visits: 836
This is a great introduction to a robust purely internal solution. I would like to recommend Jason Thomas' solution of building a dynamic URL image call to an external service if the data isn't overly sensitive and the amount of calls is relatively low.
Post #1530570
Posted Tuesday, January 14, 2014 2:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:21 AM
Points: 13,236, Visits: 11,006
Great, detailed article. Thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1530577
Posted Tuesday, January 14, 2014 4:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 22, 2014 4:42 AM
Points: 10, Visits: 222
1. I agree with Steph on using an external service and a link. If that is not possible, then do not install the dll into the GAC as it will cause future headaches in the future for sure. Instead, just reference the dll through a simple path file.

2. Fully test the QR Code by scanning them though a real scanner device not just a software one if your reports containing any barcode will be printed and read by real scanners out there. Barcoding seems to be simple (and it is) if it's performed correctly which means you use a good barcode encoder (we can help on this), you test it with a real device AND you get it verified by using a verifier device.

3. By the way, the link to the QR Code spec file is illegal. Look, QR Code is public BUT you have to pay for a license to ISO organization! That pdf file has this watermark at every page

"Licensed to SCANBUY, INC./ASHISH MUNI
ISO Store order #:762844/Downloaded:2006-08-01
Single user licence only, copying and networking prohibited"

The last phrase is far than clear


Tools for SSRS, ASP.NET & PHP
Barcode CRI for SSRS
Post #1530603
Posted Tuesday, January 14, 2014 5:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, June 8, 2014 1:45 AM
Points: 14, Visits: 53
After trying the code, the images generated seem unreadable by a cell phone. Is that expected somehow?

The online code reader at zxing does recognize it, but iPhone or Lumia phones were unable to read it

Thanks.
Post #1530620
Posted Tuesday, January 14, 2014 6:01 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 9, 2014 8:47 AM
Points: 128, Visits: 918
To tell you the truth, I wrote this as a way of learning how to do QR Codes. I need a project when I want to learn something new.

It took me a long time to figure out this much. It's probably not optimal. I just wanted to share what I had learned in the hopes that somebody else might teach me a little more.

The QRCode.Net project (http://qrcodenet.codeplex.com/) looks to be a little more robust, but I haven't found my way into it yet. If anybody can point me in a direction I will write another article if I get it to work and if it works better.
Post #1530923
Posted Wednesday, January 15, 2014 12:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, June 8, 2014 1:45 AM
Points: 14, Visits: 53
Thanks Stan for clarifying. I agree with you, it is worth investigating :)

So far, we know that the QR codes created with the tools in this article are not compatible with all devices.
Post #1530957
Posted Wednesday, January 15, 2014 4:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 22, 2014 4:42 AM
Points: 10, Visits: 222
Tell me what code value you tried to encode and send me the QR Code you got there. Look, smart devices run barcode reader software and they have bugs as any other software. Again, they are not truly barcode reader scanners. So it could be an issue related to the QR Code encoder OR to the software reader running on your device.

LeoZ


Tools for SSRS, ASP.NET & PHP
Barcode CRI for SSRS
Post #1531019
Posted Wednesday, January 15, 2014 6:50 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 9, 2014 8:47 AM
Points: 128, Visits: 918
I created a JPG from the string "SQL Server Central" you can download here:

https://app.box.com/s/ozylup0fhkeen56vqpyd
Post #1531082
Posted Wednesday, January 15, 2014 8:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, June 8, 2014 1:45 AM
Points: 14, Visits: 53
Thanks a lot Stan. I got the same results with your image so far. The phone cannot read it.

Other QR codes from the web seem OK to phones, I wonder what's missing here.
Post #1531124
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse