How to show QR code using Google Charts in Crystal reports?
Currently I managed to show inside Crystal report QR code using Google Charts and dynamically change path of picture but the generated QR code is wrong. I need to show URL with GET methode (3 params) and link is showing only 1st param.
test URL which needs to be opened via QR code (formula "link")
"http://test.com/getData?param1=aaa¶m2=bbb"
formula for QR code and dynamically changing picture (it's http because Crystal Reports doesn't support https)
"http://chart.googleapis.com/chart?cht=qr&chs=200x200&chl=" + {@link}
Those two combined form a string
http://chart.googleapis.com/chart?cht=qr&chs=200x200&chl=http://test.com/getData?param1=aaa¶m2=bbb
QR code - wrong one (missing param 2)
If I change my link to (url encoding & into %26)
http://chart.googleapis.com/chart?cht=qr&chs=200x200&chl=http://test.com/getData?param1=aaa%26param2=bbb
then I get with browser good QR code but in Crystal reports still wrong one (missing param 2)
QR code - good in browser but not showing the same in Crystal
I suspect that something is wrong with URL encoding in Crystal or different than browser encoding. Any suggestions how to solve this?
After lots of hours trying encoding/decoding data I accidently figure out that it wasn't problem in data or URL. Only thing I had to do is check "use original URL" in picture properties. After that generated QR code was good and problem solved. Hope it helps someone and saves lots of hours.
- Understanding the difference in timing of two functions that increment each element of an integer array
- Why MSVC generates warning C4127 when constant is used in "while" - C
- Executing a user-space function from the kernel space
- Why must the variable used to hold getchar's return value be declared as int?
- mpirun -np 4 ./a.out doesn't use all my cores (ubuntu 24.04LTS)
- Shadowing an iterator inside a for loop has undefined (?) behaviour in C
- Sleep for N seconds and wait for keypress
- Dereference twice in gdb
- Is this declaration UB?
- return type defaults to 'int' [-Wimplicit-int]
- What is the scope of `fesetround()`?
- Which specific optimization flag causes libm functions to be treated as pure?
- How to render text in SDL2?
- Why would you use 'extern "C++"'?
- Strange Behavior Compiler Ignoring NULL Check Unless I Print Something in the if Statement
- Fast inverse square root using fixed point instead of floating point
- What is the const qualifier attached to in C: the memory area or the pointer?
- GCC options for strictest C code?
- How to do an explicit fall-through in C
- How do compilers treat CONST qualifier when the pointer points to a memory location obtained with malloc()?
- C: cmocka headers - how to unittest?
- Why in C when I print a double with a one decimal it round it to the next number
- Android C to Java SWIG unable to compile: incompatible types: byte cannot be converted to SWIGTYPE_p_uint8_t
- GNU Make in Ubuntu giving fatal error: rpc/types.h: No such file or directory
- How can I exclude non-numeric keys? CS50 Caesar Pset2
- How change every struct in an array of pointers?
- Optimized 2x2 matrix multiplication: Slow assembly versus fast SIMD
- Simple frame by frame video decoder library
- GCC no longer implements <varargs.h>
- Contents of IO buffer unknown == unsafe?