cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic QR-Code thru URL in a OLE-Object for printing Label with QR-Code

nti
Discoverer
0 Kudos
Hi y'all;
we used in our Label a QR Code we got dynamiclly over API Google Charts. Now Google discontinued this service so i got a simalaer service called quickcharts.io but Crystal Report doesnt show me the QR Code.
When i try the Link in the browser it works...
 
The old working string:
"http://chart.apis.google.com/chart?cht=qr&chs=250x250&chl="& {Etikett_25020.ZEILE9}

The new NOT working string:
"https://quickchart.io/chart?cht=qr&chs=250x250&chl="& {Etikett_25020.ZEILE9}
 

Please HELP!


 
View Entire Topic
ido_millet
Active Contributor
0 Kudos

afaik, Crystal doesn't support https.  But you can do this using a Crystal UFL (User Function Library).
At least one of the 3rd-party UFLs listed here provides a function that supports getting an image from an https url.

Better yet -- one of these UFLs also provides functions to directly generate various types of barcode images (including QR) and dynamically load them into the report (using the Graphic Location expression of a dummy image). 

nti
Discoverer
0 Kudos
I'm new into this, i have no idea how to use these UFL's 😞 Is there no way that Crystal reports excepts https? Isn't anyway better than unsecured http?
ido_millet
Active Contributor
0 Kudos

A UFL, once installed, simply gives you additional functions within Crystal.

You point about how reasonable it is to support https is valid. But we don't control how Crystal behaves. We can, however, work around Crystal's limitations. 

nti
Discoverer
0 Kudos
Thanks for your replies! 🙂 But where do i install it? On the PC which generates the Report? Or just on my PC where i edit the Report?
ido_millet
Active Contributor
0 Kudos
You install the UFL (it's just a dll) on any machine that needs to run the report.
nti
Discoverer
0 Kudos
Which one is the UFL for creating a QR-Code from a "Number"?