Post reply

Generate QR Code® barcodes in an SSRS report with the QRCoder library

  • October 21, 2018 at 9:25 am

    #366168

    Comments posted to this topic are about the item Generate QR Code® barcodes in an SSRS report with the QRCoder library

  • October 22, 2018 at 4:51 am

    #2010545

    Thanks for posting this!

    My favorite resource for QR Codes is: 

    https://www.nayuki.io/page/qr-code-generator-library

  • October 22, 2018 at 5:35 am

    #2010549

    Great article about inserting QR Codes in SSRS reports. One problem with that approach is the need to install the dll into the system GAC. You can avoid that by registering the dll in the Visual Studio RSPreviewPolicy.config file with an entry similar to this one:

    <CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust" Name="MyQRCode" Description="This code group grants FullTrust to MyQRCode assembly.">  <IMembershipCondition class="StrongNameMembershipCondition" version="1" PublicKeyBlob="000000............0000000" /></CodeGroup>

    The PublicKeyBlob for your dll assembly can be obtained in this way 

    Then that same entry must be added to the SSRS rssrvpolicy.config file
    These settings should rid off the need of registering the dll into the GAC.
    For more advanced barcode options as well as another 2D types like DataMatrix, DotCode, PDF417, etc and for a visual barcode CRI you might try other alternatives like BP for SSRS

    HTH

    Tools for SSRS, ASP.NET & PHP
    Barcode CRI for SSRS[/url]

  • November 14, 2018 at 4:02 pm

    #2013571

    Robert Sterbal-482516 - Monday, October 22, 2018 4:51 AM

    Thanks for posting this!

    My favorite resource for QR Codes is: 

    https://www.nayuki.io/page/qr-code-generator-library

    Unfortunately it doesn't appear that they have a C# version.

  • February 8, 2019 at 4:01 pm

    #2021578

    hi
    Thanks for posting this,
    But Be careful friends dlls in "StronglyNamedPartiallyTrustedCallersDLLs" Folder deploy on ssrs>2014
    "Error while loading code module: ‘QRCoderImageToByteArray, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3016ec4525f0585e’. Details: Could not load file or assembly 'QRCoderImageToByteArray, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3016ec4525f0585e' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded
    "
    in ssrs<=2014 .NET Framework <=3.5 is supported for Reporting Services assemblies

  • February 8, 2019 at 5:55 pm

    #2021581

    smohammadmir - Friday, February 8, 2019 4:01 PM

    hi
    Thanks for posting this,
    But Be careful friends dlls in "StronglyNamedPartiallyTrustedCallersDLLs" Folder deploy on ssrs>2014
    "Error while loading code module: ‘QRCoderImageToByteArray, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3016ec4525f0585e’. Details: Could not load file or assembly 'QRCoderImageToByteArray, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3016ec4525f0585e' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded
    "
    in ssrs<=2014 .NET Framework <=3.5 is supported for Reporting Services assemblies

    That means that you will have to compile the source code yourself. I supplied the source code I used to compile it in the attached resource file.

  • April 29, 2019 at 7:42 pm

    #3550083

    I'm sure I'm doing something wrong, but I cannot get the QRCoderImageToByteArray.dll file.

    I am unable to find the QRCoderResources.zip file, (along with the StronglyNamedPartiallyTrustedCallersDLLs folder). I've tried using the Compile.bat batch file, which did create the QRCoder.dll file, but not QRCoderImageToByteArray.dll.

    Any ideas on how I can resolve this?

  • May 8, 2019 at 5:15 pm

    #3638447

    Any luck srechner ? i am in the same boat. i couldnt find QRCoderResources.zip

     

  • May 8, 2019 at 5:59 pm

    #3638482

    Not with this solution. I ended up generating QR codes via https://api.qrserver.com.

  • May 9, 2019 at 2:02 pm

    #3639077

    SQL Server Central hasn't restored the resource files after the conversion yet.

    I scoured my hard drive and found copies of QRCoder.dll and QRCoderImageToByteArray.dll that I think are the ones I included with the article. I uploaded them to my google drive. Here is the link:

    https://drive.google.com/drive/folders/1T8hJVFhuY61bZbokC7l4SwHx3cJCoL6s?usp=sharing

  • May 9, 2019 at 3:46 pm

    #3639182

    Stan Kulp-439977, Thank you very much for your help. i will give it a try

  • May 9, 2019 at 4:28 pm

    #3639222

    Looks like they just restored the resource file to the article.

    https://www.sqlservercentral.com/wp-content/uploads/2019/04/QRCoderResources.zip

  • May 9, 2019 at 4:33 pm

    #3639228

    Brilliant . Thanks for letting us know

  • May 31, 2019 at 10:12 pm

    #3649198

    We are getting the same error...

    Error while loading code module: ‘QRCoderImageToByteArray, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3016ec4525f0585e’. Details: Could not load file or assembly 'QRCoderImageToByteArray, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3016ec4525f0585e' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.

    How do we correctly compile the source code?

    Thanks for your help!

    • This reply was modified 4 years, 10 months ago by  ArturoBandini.

  • April 9, 2021 at 6:28 am

    This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply