2015-04-07

SSRS - Create a QR report

QR code is becoming popular. So what if we put QR code into the report, such as a contact report with QR codes? Sounds interesting, isn't it? Following steps below you can create a simple report with QR code integrated, no code required!


Firstly we need a report to show some basic contact information. In this example, I just make it very sample, as shown below



Then I drag and drop a tablix control on to the report. After set first few columns, I drop an image into the last column


Now here is the interesting part: the QR code actually is coming from http://qrcode.kaywa.com/. This site can encode your input into QR code (static) and export the result as an image. And for personal use, you can create a free account. So what we need to do is to set the image property to the output of this site


As you can see, I change the image source to external, and then I set the image expression to:
 = "http://qrcode.kaywa.com/img.php?s=8&d=" + Fields!name.Value + "%0A" + Fields!site.Value + "%0A" + Fields!mob.Value  

Now run the report:


When you run the report, you may see the warning message:

"Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access."

It is because of reporting service execution account setting. To configue a default reporting service execution account, you can open Reporting Service Configuration Manager, and navigate to Execution Account page, fill in default account information, as shown below.

2 comments :

  1. Hi.
    I am generating the QR from google API URL.what account information we need to fill there.does it effect anything ??

    ReplyDelete
  2. Hi Swathireddy

    If you are referring to Google Chart API, Infographics, I just did a quick test and there should be no need to fill in your account information. Try above technics and replace the image expression to "http://chart.apis.google.com/chart?cht=qr&chs=300x300&chl=Here%20is%20what%20we%20can%20generate%20from%20google%20chart%20api".

    However you need to be careful when use the Infographics as it is a deprecated service now.

    ReplyDelete