Crystal Reports - Passing multiple querystring parameters to quickchart returns link with only the first one

1

I created the following formula on an image object in my crystal report:

“http://nossl.quickchart.io/qr?size=650&margin=2&text=” & ToText({TT_EquipmentQRCodes.QRURL})

given a url of:
mysitenamehere?param1=yes&param2=no&param3=maybe

The QR Code returns a url that only has the param1 parameter. The others are not there.
mysitenamehere?param1=yes

All ampersands and text following it are cut off. Is there any way to pass multiple querystring parameters?

2

Nevermind. After reading the documentation a bit more, I tried URL Encoding the entire URL and it worked. Originally, I tried simply url encoding the “&” symbol since that was giving me the problem which didn’t work. Once I ran through and encoded ALL of the special characters, I got the URL I was expecting.

Applied SQL logic I found here: sql - TSQL - How to URL Encode - Stack Overflow to my source data and I was good to go.

1 Like