First picture repeating in next rows in crystal reports problem what wrong code

Posted by Ahmedsa under C# on 2/18/2015 | Points: 10 | Views : 1125 | Status : [Member] | Replies : 1
Hi guys i try to show more pictures in crystal reports but my version of crystal report not allow to me to make link pictures meaning
picture tab not have graphic location formula in crystal report
Now what i do to solve this problem
i try from code to do that it working from code below but
first picture repeating in next rows
my code as following (only show one picture)
DataTable dt = new DataTable();
string connString = "data source=192.168.1.105; initial catalog=hrdata;uid=sa; password=1234";
using (SqlConnection con = new SqlConnection(connString))
{
con.Open();
SqlCommand cmd = new SqlCommand("ViewEmployeeNoR", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);
}
FileStream fs=null;
fs = new FileStream("\\\\192.168.1.105\\Personal Pictures\\" + ".jpg", FileMode.Open);
BinaryReader br = new BinaryReader(fs);
byte[] imgbyte = new byte[fs.Length + 1];
imgbyte = br.ReadBytes(Convert.ToInt32((fs.Length)));
foreach (DataRow dr in dt.Rows)
{
dr["Image"] = imgbyte;
}
ReportDocument objRpt = new Reports.CrystalReportData2();
objRpt.SetDataSource(dt);
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();
Now what modification i must do to prevent first picture from repeating in next records
Crystal report show ID AND Image




Responses

Posted by: Balaram on: 2/18/2015 [Member] Starter | Points: 25

Up
0
Down
hi store the image angle in roothpath then u ill solve the first picture repeating in next rows,
try to use the below code

string file = pa.Photos[itemIndex].FileName;
int angle = Convert.ToInt32(pa.Photos[itemIndex].RotatedAngle);
string rootPath = Convert.ToString(ConfigurationManager.AppSettings["FCCStorageRoot"]);
rootPath = rootPath + file;
//create an image object from the image in that path
rootPath = rootPath.Replace(pa.Photos[itemIndex].DisplayName, "Thumbnails\\" + pa.Photos[itemIndex].DisplayName);
System.Drawing.Image img = System.Drawing.Image.FromFile(rootPath);
//rotate the image
img.RotateFlip(RotateFlipType.Rotate90FlipNone);

img.Save(rootPath);
img.Dispose();

Ahmedsa, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response