Unable to show QR image of in crystal report

Question

0.00/5 (No votes)

See more:

I'm working with Crystal report 9. I am generating my QR Code images from Google QR Code (infographics) after getting the images from the link we insert an image into the database field.

I have some QR Codes in my database (SQL Server) as an IMAGE datatype. I'm getting the data using the stored procedure, everything is working fine except the image which is not showing in the Crystal Report blob field.

Blob field is not showing images just for 1-2 QR Codes except that every QR code is showing properly.

I have a few questions which are the following:
Does anyone has faced this kind of issue?
How can we get the difference between all showing QR codes and not showing QR codes?
How can I be able to show that QR Code?
Link 1 (Not working )
Link 2 (working)

What I have tried:

Generating QR Code from another way.
Changed table column to varbinary(max) as mentioned in some solutions.

Only one of my Qr code is not showing else everything works fine.

Posted 12-Jan-21 2:50am

Member 13327366

Updated 13-Jan-21 19:26pm

Suvendu Shekhar Giri

v2

Add a Solution

Comments

[no name] 12-Jan-21 9:56am

If all the others work, the 1-2 images that didn't work are either: missing or corrupt. Not something someone else can fix.

Member 15021641 13-Jan-21 0:14am

Hey Gerry thanks for the comment. But my all images are correct not a single one is corrupted .I am saying this cause when I scan the QR code from images it give me the exact result as I encoded into the QR Code. For more you can also generate the QR code from the above which I have given.

[no name] 14-Jan-21 9:56am

You should then run your own "loop" (c#, sql select, whatever) and retrieve display all the images. If that works and CR still doesn't, then it's how you're "feeding" CR. You're the one that tells CR how and what to report on, short of you feeding it a dataset / datatable (with images) directly.

And what's a CR "blob" field have to do with an "image"? No "picture box" or "image type"?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)