SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Generate two-dimensional QR Code® bar codes in an SSRS report


Generate two-dimensional QR Code® bar codes in an SSRS report

Author
Message
Stan Kulp-439977
Stan Kulp-439977
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1362 Visits: 1131
Comments posted to this topic are about the item Generate two-dimensional QR Code® bar codes in an SSRS report
Steph Locke
Steph Locke
Old Hand
Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)Old Hand (367 reputation)

Group: General Forum Members
Points: 367 Visits: 870
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.
Koen Verbeeck
Koen Verbeeck
SSC-Dedicated
SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)

Group: General Forum Members
Points: 34219 Visits: 13270
Great, detailed article. Thanks.


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

MCSE Business Intelligence - Microsoft Data Platform MVP
Neodynamic
Neodynamic
SSC Journeyman
SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)

Group: General Forum Members
Points: 80 Visits: 223
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
a.abalos.castillo
a.abalos.castillo
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 57
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.
Stan Kulp-439977
Stan Kulp-439977
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1362 Visits: 1131
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.
a.abalos.castillo
a.abalos.castillo
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 57
Thanks Stan for clarifying. I agree with you, it is worth investigating Smile

So far, we know that the QR codes created with the tools in this article are not compatible with all devices.
Neodynamic
Neodynamic
SSC Journeyman
SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)SSC Journeyman (80 reputation)

Group: General Forum Members
Points: 80 Visits: 223
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
Stan Kulp-439977
Stan Kulp-439977
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1362 Visits: 1131
I created a JPG from the string "SQL Server Central" you can download here:

https://app.box.com/s/ozylup0fhkeen56vqpyd
a.abalos.castillo
a.abalos.castillo
SSC Journeyman
SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)SSC Journeyman (91 reputation)

Group: General Forum Members
Points: 91 Visits: 57
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search