How to add a QR-code to a report in SSRS?

I stumbled upon this blog post by Jason Thomas, which is a walkthrough on how to add QR-codes to your reports in SQL Server Reporting Services (SSRS):

SSRS-QR-code

It’s actually quite simple, you’ll need to use an expression such as:
="http://qrcode.kaywa.com/img.php?s=8&d=" + Fields!name.Value + Constants.vbcrlf + Fields!URL.Value + Constants.vbcrlf + Fields!mob.Value

Where the dataset looks like:

SELECT 'Jason Thomas' AS name, 'www.road-blogs.blogspot.com' AS URL, '00447574713732' AS mob
UNION ALL
SELECT 'Jay Thomas' AS name, 'www.beyondrelational.com' AS URL, '67891' AS mob
UNION ALL
SELECT 'Jean Elizabeth' AS name, 'http://twitter.com/de_unparagoned' AS URL, '12345' AS mob

Customer-expression-SSRS-QR-Code

The full blog post can be found here:
http://www.sqljason.com/2011/10/generating-qr-codes-in-ssrs.html





Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s