QRCODE Having Ireport Problems

Asked

Viewed 22 times

-2

My Qrcode is printing as follows on iReport, this way is in trouble:

QRcode Gerado com problemas

Correct would be in this format:

inserir a descrição da imagem aqui

I have already realized all the necessary configurations for the operation of it.

1 - I added the necessary libraries

inserir a descrição da imagem aqui

2- I added Field by passing the Image expression.

inserir a descrição da imagem aqui

3 - My query is as follows

inserir a descrição da imagem aqui

1 answer

0


In the SQL query I was using the CRC16 field without any treatment, this field had a blank space at the end, causing the problem, because the code was breaking.

I made the following change in the field, to remove the spaces, so the problem was solved and Qrcode was successfully generated.

RTRIM(LTRIM(CONVERT(VARCHAR(MAX),CRC16))) AS URL1

QRcode gerado em meu sistema

Browser other questions tagged

You are not signed in. Login or sign up in order to post.