Click here to Skip to main content
Click here to Skip to main content

How to dynamically load images in Crystal Reports using Visual Studio 2005

By , 19 Nov 2008
Rate this:
Please Sign up or sign in to vote.

Introduction

If you have an image path that is stored in your database, Crystal Reports .NET in Visual Studio 2003/2005 cannot display the image file dynamically unless you use the dynamic image location feature in Crystal Report XI.

I searched in the Web, and I found how to display this using a workaround.

Using the code

We must have a field (image path) in our database. We need to create a new DataSet/XML schema (XSD) (TypedDataSet) to use as resource data in creating a report, and add an additional field that is not in the table and which is of type base64Binary:

Or add it in XML:

< name="”image_stream”" type="”xs:base64Binary”" minoccurs="”0″">

When designing a report, drag and drop the “image_stream” field in the region where you want it to appear. Add CrystalReportViewer to your ASPX page. In the code-behind of your page, add the following method to load the image:

private void LoadImage(DataRow objDataRow, string strImageField, string FilePath)
{
    try
    {
        FileStream fs = new FileStream(FilePath, 
                   System.IO.FileMode.Open, System.IO.FileAccess.Read);
        byte[] Image = new byte[fs.Length];
        fs.Read(Image, 0, Convert.ToInt32(fs.Length));
        fs.Close();
        objDataRow[strImageField] = Image;
    }
    catch (Exception ex)
    {
        Response.Write("<font color=red>" + ex.Message + "</font>");
    }
}

We need to fill the TypedDataSet, and before assigning this DataSet to the “SetDataSource” of our report, we need to add a few lines of code:

TypedDataSet ds = new TypedDataSet();

SqlConnection cn = new SqlConnection("Data Source=ServerName;" + 
                   "Initial Catalog=DataBaseName;User ID=UserName;" + 
                   "Password=UserPassWord");
SqlCommand Cmd = new SqlCommand();
SqlDataAdapter myAdapter = new SqlDataAdapter();

Cmd.CommandText = " Select * From TableName";
Cmd.Connection = cn;

myAdapter.SelectCommand = Cmd;

try
{
    cn.Open();
    myAdapter.Fill(ds.Tables[0]);
    cn.Close();
}
catch (Exception ex)
{
    throw;
}


for (int index = 0; index < ds.Tables[0].Rows.Count; index++)
{
    if (ds.Tables[0].Rows[index]["image_path"].ToString() != "")
    {
        string s = this.Server.MapPath(
                    ds.Tables[0].Rows[index]["image_path"].ToString());

        if (File.Exists(s))
        {
            LoadImage(ds.Tables[0].Rows[index], "image_stream", s);
        }
        else
        {
            LoadImage(ds.Tables[0].Rows[index], "image_stream", 
                      "DefaultPicturePath");
        }
    }
    else
    {
        LoadImage(ds.Tables[0].Rows[index], "image_stream", 
                  "DefaultPicturePath");
    }
}

try
{
    // Finally display report in crystal report viewer
    ReportDocument crDoc = new ReportDocument();
    crDoc.Load(Server.MapPath("CrystalReport.rpt"));
    crDoc.SetDataSource(ds.Tables[0]);
    CrystalReportViewer1.ReportSource = crDoc;
}
catch (Exception ex)
{
    throw;
}

Thanks

I would like to thank the CodeProject team (moderators, users, visitors...) for all their effort. Thank you everybody.

License

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

About the Author

Redouane Mounafia
Team Leader
Morocco Morocco
No Biography provided

Comments and Discussions

 
Generalpdf too large Pinmemberyi23-Oct-10 23:51 
GeneralFor desktop Pinmembershailesh_j2-Dec-09 20:25 
GeneralRe: For desktop PinmemberRedouane Mounafia3-Feb-10 5:18 
GeneralThanks PinmemberWags6-Aug-09 22:25 
GeneralRe: Thanks PinmemberRedouane Mounafia7-Aug-09 8:30 
GeneralNot working with VB.net 2003 Pinmembersachinse14-Jun-09 21:11 
GeneralImage not showing Pinmemberdannystommen3-Apr-09 4:34 
GeneralRe: Image not showing Pinmemberdannystommen6-Apr-09 23:12 
GeneralI don't see any picture - Need help Pinmembersharabi_liran2-Feb-09 20:29 
QuestionThanks & Need your help PinmemberRajeeshun12-Jan-09 10:43 
AnswerRe: Thanks & Need your help PinmemberRedouane Mounafia12-Jan-09 12:09 
GeneralThanks! A note... PinmemberDigambar Kandangire27-Nov-08 3:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.140415.2 | Last Updated 19 Nov 2008
Article Copyright 2008 by Redouane Mounafia
Everything else Copyright © CodeProject, 1999-2014
Terms of Use
Layout: fixed | fluid