How Show Image On Report On Rdlc Which Stored In Database In Binary Format.

Question

0.00/5 (No votes)

See more:

Hi everyone I want to show image on report on rdlc which stored in database in binary format. How can i show the image on report of rdlc.

In Select the image source, select Database.
In Use this Field, select the field that contains the image.
In Use this MIME type, select the MIME type of the image.
Click OK.

above thing is not worked for me

Posted 30-Sep-15 1:26am

Member 11964195

Updated 30-Sep-15 1:27am

v2

Add a Solution

2 solutions

Add a Solution

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)

MashaJoey · Answer 1 · 2015-09-30T03:02:00

Solution 1

hmmm do you have the option to change the type you store in the database, you can change by using base64 instead of binary which i find easier to use in rdlc, if you do decide to use base 64 try adding

=Convert.FromBase64String(Convert.ToString(Fields!Barcode.Value).Replace("data:image/jpeg;base64,","").Replace("data:image/png;base64,",""))

in the image box properties, under general, "Use this field" expression.

Sorry if my English is really bad.

Posted 30-Sep-15 3:02am

MashaJoey

Comments

adminehealthcare 4-Dec-20 23:38pm

Thank you so much. you just saved my day.

AmaniCodes 21-Jan-21 5:49am

It's amazing ..its helped me and solved my issue
I saved the QR as string base64 and just applied this its working now
thankyou very much

CB Sharma · Answer 2 · 2015-09-30T03:19:00

Solution 2

Hi,

May be the following link is useful to you.

http://www.c-sharpcorner.com/Blogs/6194/display-image-in-rdlc-report-microsoft-report-viewer.aspx[^]

Posted 30-Sep-15 3:19am

CB Sharma