I have been trying to add image in my crystal report.

I have been trying to Print Id Card With Employee Image and Compay logo in my crystal report. I have able to get the path from database. i placed the path in my crystal report. instead of printing the Employee Photo and Logo, it prints the path.In database i have taken varchar datatype for both photo and logo.

this is my c# code

EmployeeDetailsForIdCardBL bl = new EmployeeDetailsForIdCardBL();

FileName = "Employee IdCard Report";

string empcode = strRequestNo.ToString();

DataSet dsemployeeIdCard = new DataSet();

DataTable dtCommonReportViewCRV1 = new DataTable();

dsemployeeIdCard = bl.GetIndivisaulIdCardForPrint(empcode);

dtCommonReportViewCRV1 = dsemployeeIdCard.Tables[0];

//if (dtCommonReportViewCRV != null)

//{

// dtCommonReportViewCRV1.WriteXmlSchema(Server.MapPath(".") + "\\App_Code\\IdCard.xsd");

//}

rptDoc.Load(Server.MapPath(".") + "\\ID Details.rpt");

//dtCommonReportViewCRV.TableName = "Table1";

string logo = "";

if (dsemployeeIdCard != null)

{

logo = dsemployeeIdCard.Tables[0].Rows[0]["logoFile"].ToString();

}

FileStream fs = new FileStream(Server.MapPath(@"./photos/" + logo), FileMode.Open);

BinaryReader br = new BinaryReader(fs);

byte[] pic = br.ReadBytes((int)fs.Length);

br.Close();

dtCommonReportViewCRV1.Columns.Add("logoFile1", typeof(byte[]));

for (int i = 0; i < dtCommonReportViewCRV.Rows.Count; i++)

{

dtCommonReportViewCRV1.Rows[i]["logoFile1"] = pic;

}

string Empphoto = "";

if (dsemployeeIdCard != null)

{

Empphoto = dsemployeeIdCard.Tables[0].Rows[0]["empphoto"].ToString();

}

string strEmpphotoPath = Server.MapPath(@"./EmpPhotos/" + Empphoto);

FileStream fs1 = new FileStream(strEmpphotoPath, FileMode.Open);

BinaryReader br1 = new BinaryReader(fs1);

byte[] photo = br1.ReadBytes((int)fs1.Length);

br1.Close();

if (dsemployeeIdCard != null && dsemployeeIdCard.Tables.Count > 0 && dsemployeeIdCard.Tables[0].Rows.Count > 0)

{

dsemployeeIdCard.Tables[0].Columns.Add("EmployeePhoto", typeof(byte[]));

for (int i = 0; i < dsemployeeIdCard.Tables[0].Rows.Count; i++)

{

dsemployeeIdCard.Tables[0].Rows[i]["EmployeePhoto"] = photo;

}

if (dtCommonReportViewCRV1.Rows.Count > 0)

{

rptDoc.SetDataSource(dtCommonReportViewCRV1);

ConnectionInfo crConnectionInfo = new ConnectionInfo();

crConnectionInfo.ServerName = strSAPDATABASESERVER;

crConnectionInfo.DatabaseName = strDataBaseName;

crConnectionInfo.UserID = strSAPDATABASEUSERID;

crConnectionInfo.Password = strSAPDATABASEUSERID;

TableLogOnInfo crTableLogoninfo = new TableLogOnInfo();

foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in rptDoc.Database.Tables)

{

crTableLogoninfo = CrTable.LogOnInfo;

crTableLogoninfo.ConnectionInfo = crConnectionInfo;

CrTable.ApplyLogOnInfo(crTableLogoninfo);

}

PrintReportViewCRV.ReportSource = rptDoc;

}

byteArray = null;

oDocStream = rptDoc.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);

byteArray = new byte[oDocStream.Length];

oDocStream.Read(byteArray, 0, Convert.ToInt32(oDocStream.Length - 1));

Response.ClearContent();

Response.ClearHeaders();

Response.ContentType = "application/pdf";

Response.AddHeader("Content-Disposition", "attachment; filename=" + FileName + ".pdf");

Response.BinaryWrite(byteArray);

Response.End();

rptDoc.Close();

rptDoc.Dispose();

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Basavaraja Hariyavvanavar9y ago
Hi Thanks for Reply,

Problem is solved i have done like this i have insert ole object, select any image from the folder path where i saved images and check the link check box put it in report later right click on selected image go to format object select picture tab and Select X-2 near graphic location it redirect to formula editor theire expand stored procedure and select photo and add fullpath where photo is stored like below
'E:\Basavaraja\June2017\P\Pt\Web\PWeb\EmpPhotos'+'\'+{Command.empphoto}
than it dynamically selecet image from database
0
Khaja Moizuddin9y ago
Try to explore from google , what ever error and issue you face ,there are a lot of documents available in internet. https://stackoverflow.com/questions/19397893/crystal-reports-insert-an-image-in-the-report-header-section https://forums.asp.net/t/1933890.aspx?How+to+dynamically+add+images+in+crystal+report https://www.codeproject.com/Articles/21095/Image-in-Crystal-Reports http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/how-to-display-jpg-file-in-crystal-report-using-file-path-from-sql-table-1640366
0