Cyrstal Reports, Stored Procedure and C#

[vivek_nz76]

Hi,

I have a dataset with more than 1 datarows and I cannot get to display all the rows. The code looks like this. It shows the last row.

************************************************************
Timesheet tsRpt = new Timesheet();

CJob CJ = new CJob();

DataSet ds = CJ.GetTimeSheetOrgID_Week(Convert.ToInt32(Request.QueryString["ChOrgID"].ToString()), Convert.ToDateTime(Request.QueryString["WeekEndDate"].ToString()));

if (ds.Tables[0].Rows.Count > 0)
{
tsRpt.SetDataSource(ds);

foreach (DataRow dr in ds.Tables[0].Rows)
{
tsRpt.SetParameterValue("JobNo",dr["JobID"].ToString());
tsRpt.SetParameterValue("OrderNo",dr["CustRef"].ToString());
tsRpt.SetParameterValue("Name", dr["ConID"].ToString() + ". " + dr["Name"].ToString());
tsRpt.SetParameterValue("Monday", dr["Monday"].ToString());
tsRpt.SetParameterValue("Tuesday", dr["Tuesday"].ToString());
tsRpt.SetParameterValue("Wednesday", dr["Wednesday"].ToString());
tsRpt.SetParameterValue("Thursday", dr["Thursday"].ToString());
tsRpt.SetParameterValue("Friday", dr["Friday"].ToString());
tsRpt.SetParameterValue("Saturday", dr["Saturday"].ToString());
tsRpt.SetParameterValue("Sunday", dr["Sunday"].ToString());
tsRpt.SetParameterValue("TotalHours", dr["HoursWorked"].ToString());

}

}

CrystalReportViewer1.ReportSource = tsRpt;

************************************************************