Blob Fields in Crystal Reports using ASP.Net

Question

I tried various methods given online to insert an image in Crystal Reports dynamically from database but it did not work for me. The Image is still not getting displayed. I have tried doing it by using database expert, dataset and setting graphic location for a picture field but still no result. I have tried all methods possible I could find online.

I am using VS 2013 as my front end, SQL Server 2008 as back end and Crystal Reports version 13.

Thank you in advance

Where exactly would you have the images? (stored in database, stored in server with path stored in database, ...) — Moises Quintero
– Moises Quintero, Commented Apr 15, 2016 at 6:05

Moises Quintero · Accepted Answer · 2016-04-15 05:47:52Z

0

Since VS 2013 open your rpt file (not the cs code associated), over this, click with secondary button and select insert -> image -> browse in your computer image file. Later at moment to open the image you will paste in the rpt file (you will view first a rectangle with preliminar location of the image). In this way your image file will be converted to OLE Object inside rpt file (cristal reports file inside VS2013 Project).

answered Apr 15, 2016 at 5:47

Moises Quintero

768 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kr16 Over a year ago

thank you for your reply, but i need dynamic images from database

Heemanshu Bhalla · Accepted Answer · 2025-11-21 20:30:42Z

In order to use Blob image on Crystal report you need to pass byte / binary data from c# inside your dataset that you are connecting to report rpt file. check below suggestion if you have path of image file retrieved from database

Add Image Property to dataset with Type in byte. this property will be placed on crystral report from dataset on report

ds.Tables[0].Columns.Add("Image", typeof(byte[]));

Below code is for converting the image from a path to Byte to transfer it to .rpt file that has blob type field for this.

string path12 = "path of image from database";
       
        FileStream fs19 = null;
        try
        {
            fs19 = new FileStream(path12, FileMode.Open);
            using (BinaryReader br19 = new BinaryReader(fs19))
            {
                byte[] imgbyte = br19.ReadBytes((int)fs19.Length);
                ds.Tables[0].Rows[i]["Image"] = imgbyte;
                fs19 = null;
            }
        }
        catch (Exception)
        {
            // Handle exception if needed
        }
        finally
        {
            if (fs19 != null)
            {
                fs19.Dispose();
            }
        }

Collectives™ on Stack Overflow

Blob Fields in Crystal Reports using ASP.Net

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related