Crystal Reports XI + QRCode
Hi guys!
I have a report that prints identification labels for our products. One of the printed fields is the product's QRCode.
I'm using the google API to generate this QRCode. If I copy the link and open it in the browser, the QRCode appears normally, but if I run the report, the QRCode does not appear.
Here is an example of how I build the link:
'http://chart.googleapis.com/chart?chs=100x100&cht=qr&chl=' + Replace (ToText ({VGP0006.ID_PRODUTO}, 0), '.', '')
I've tried using "http:" and "https:" but in neither case does it work. This link is inside a formula in my report.
The only PC I can run the report on and display the QRCode correctly is where the Developer version of Crystal Reports is installed.
Has anyone been through this that can help me?
Regards
Re: Crystal Reports XI + QRCode
does the link work on the other computers that are not the development PC?
Maybe it's the google API security that's biting you?
Probably not, since this works for me...
[URL]https://chart.googleapis.com/chart?chs=100x100&cht=qr&chl=OneFineDayinTheMiddleOfTheNight[/URL]
Re: Crystal Reports XI + QRCode
[QUOTE=Michael Mullan;352477]does the link work on the other computers that are not the development PC?
Maybe it's the google API security that's biting you?
Probably not, since this works for me...
[URL]https://chart.googleapis.com/chart?chs=100x100&cht=qr&chl=OneFineDayinTheMiddleOfTheNight[/URL][/QUOTE]
Yes.
If I copy and paste the link in the browser, the QRCode appears normally on any PC on my network. It just doesn't work when I run Crystal. The only PC that works using Crystal is where the Developer version is installed.
Re: Crystal Reports XI + QRCode
Fernando,
Perhaps you are using a function from some CR dll that is not distributed to the client pc?
Regards,
Leon Raafs
Re: Crystal Reports XI + QRCode
[QUOTE=LeonRaafs;352479]Fernando,
Perhaps you are using a function from some CR dll that is not distributed to the client pc?
Regards,
Leon Raafs[/QUOTE]
I don't use any particular CR dll function on that report.
The QRCode that I generate is inside a formula field, like I posted on my 1st message.
It's a simple report, that read a particular product ID and print their info
Re: Crystal Reports XI + QRCode
Fernando,
You could very well use DataFlex Reports with its internal barcode (QR code included) support. The DataFlex 19.1 examples shows the usage of a QR code generation and the help file also contains a QR code example.
Re: Crystal Reports XI + QRCode
[QUOTE=Vincent Oorsprong;352512]Fernando,
You could very well use DataFlex Reports with its internal barcode (QR code included) support. The DataFlex 19.1 examples shows the usage of a QR code generation and the help file also contains a QR code example.[/QUOTE]
Vincent,
Unfortunately I need to use Crystal Reports to print these labels.
The strange thing is that only the machine that has the Developer version is working correctly. Any other station that has only the Crystal runtime, the QRCode does not appear.
Regards
Re: Crystal Reports XI + QRCode
Fernando,
Where did you get the crystal runtime from? If you did not make this yourself the maker probably forgot to add a module.
But, looking at your options, Crystal XI is old, very old and fully unsupported. I would advise not to spend time on this and switch to something new/different.
1 Attachment(s)
Re: Crystal Reports XI + QRCode
[QUOTE=Vincent Oorsprong;352524]Fernando,
Where did you get the crystal runtime from? If you did not make this yourself the maker probably forgot to add a module.
But, looking at your options, Crystal XI is old, very old and fully unsupported. I would advise not to spend time on this and switch to something new/different.[/QUOTE]
Vincent,
I use this runtime installer of Crystal XI:
[ATTACH=CONFIG]13494[/ATTACH]
And like I said, the QRCode works like a charm where the Developer version of Crystal XI is installed. The issue happens only on workstations with CR runtime
Regards
Re: Crystal Reports XI + QRCode
I think the previous suggestion of a missing dll is most likely. It could be that the installer for the runtime is not installing 100% of the files the original CR developer version is. I think it'd help to compare what files are on each machine & see if any are missing.