Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Generate two-dimensional QR Code® bar codes in an SSRS report Expand / Collapse
Author
Message
Posted Wednesday, January 15, 2014 9:17 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, October 19, 2016 6:38 AM
Points: 159, Visits: 1,086
I started working on QR Codes for a work project that was going to be on a secure server not connected to the Internet, so the external service was not an option. I wasn't able to come up with anything and the requirement was dropped, but it bugged me and I just decided to figure out how to generate QR Codes programmatically.

I got this far, and I thought I might just share my knowledge on the chance that somebody else would show me a better way.
Post #1531180
Posted Wednesday, January 15, 2014 10:15 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, October 19, 2016 6:38 AM
Points: 159, Visits: 1,086
Try downloading the binaries and application from here...

http://www.codeproject.com/Articles/258779/Just-launched-new-open-source-project-QrCode-Net-a

...and use the Gma.QrCodeNet.Demo.exe executable to generate some QR Codes and see if your phone can decipher them.

If it can, I am going to try to figure out how to use the accompanying Gma.QrCodeNet.Encoding.dll.

I have tried before, but got nowhere. Maybe this time will be different.
Post #1531200
Posted Wednesday, January 15, 2014 12:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 7, 2016 4:52 AM
Points: 15, Visits: 57
Thanks Stan. I have downloaded and run the code from the link you shared ("Just launched new open source project QrCode.Net at http://qrcodenet.codeplex.com").

The QR codes seem to work, however, non-regular characters are not understood properly (like Ñ, Å, Æ). The standard 128 ASCII chars work fine, so it could work with URLs.

I guess this code could be used as a DLL in Reporting Services and then solve the problem (to some point...)

Thanks again,
Antonio.
Post #1531271
Posted Wednesday, January 15, 2014 1:45 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, October 19, 2016 6:38 AM
Points: 159, Visits: 1,086
Looking at that page again, there may be enough information for me to get it to work. I will try it this weekend.
Post #1531309
Posted Wednesday, April 9, 2014 1:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:51 AM
Points: 10, Visits: 31
a.abalos.castillo (1/14/2014)
After trying the code, the qr code images generated seem unreadable by a cell phone. Is that expected somehow?

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

Thanks.


Have you tried to use any android-based phone to read the QR code? I mean it is a little strange that only the online barcode reader can read the barcode.
Post #1559817
Posted Wednesday, April 9, 2014 5:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 7, 2016 4:52 AM
Points: 15, Visits: 57
Windows phone and iPhone
Post #1559891
Posted Wednesday, August 3, 2016 1:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 25, 2016 8:56 AM
Points: 4, Visits: 24
Hi Stan,
was following your great step-by-step.

I admit I skipped hte compiling when I saw you'd attached some predone ones (mostly because hte install for Studio is still now going on).

I had a problem with 'Add references to the "System.Drawing" and "System.Windows.Forms" assemblies from the ".NET" tab of the "Add Reference" window. '.
I don`t see a .NET tab in the SSRS Reference dialog.. but I finally just went hunting and added those 2 .dll from here (c:\windows\microsoft .NET\framework\...) which got System.Drawing, Version=2.0.0.0 and System.Windows.Forms, Version=2.0.0.0 added.

I thought I was home free.. but when I hit Preview, I got:
Error while loading code module: ‘CreateQRCodeReturnByteArray, Version=1.0.0.0, Culture=neutral, PublicKeyToken=64807c980cf7c534’. Details: Could not load file or assembly 'CreateQRCodeReturnByteArray, Version=1.0.0.0, Culture=neutral, PublicKeyToken=64807c980cf7c534' or one of its dependencies. The system cannot find the file specified.

I was hoping you could help me?
HS
Post #1806806
Posted Wednesday, August 3, 2016 2:13 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, October 19, 2016 6:38 AM
Points: 159, Visits: 1,086
It sounds to me as if you have not successfully added the DLLs to the GAC (Global Assembly Cache). Just a guess.

You might try adding them using this GUI utility:

https://wingac.codeplex.com
Post #1806826
Posted Thursday, August 4, 2016 7:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 25, 2016 8:56 AM
Points: 4, Visits: 24
ok, went through the dll creation process step by step, including gac deploy.

still arguing. drat.

for adding the drawing and windows.forms to SSRS, I used the files from C:\Windows\Microsoft.NET\Framework\v2.0.50727, correct?

and took Csharp and NET.http out of the reference list for all 3 projects (if present).

even tried a gac on hte 2.0 files for drawing and forms.
Post #1807057
Posted Thursday, August 4, 2016 8:24 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, October 19, 2016 6:38 AM
Points: 159, Visits: 1,086
I wrote this a while back and don't remember everything, but I was careful to make it very thorough.

Have you tried doing the entire thing step-by-step?
Post #1807092
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse