想疯了(一个报表显示问题)在线等

Question

crtDay oRpt = new crtDay();            string strSql = "select s.Code,s.Name,o.OnDutyDay,o.UpPassTime,(select datename(weekday,'"+sDate+"') )as WeekDate,o.OffPassTime,o.LateDuty,o.EarlyDuty,o.Abnormity,o.OT from tblStaff as s,tblOnDutyNote as o where s.Code=o.StaffID and o.OnDutyDay='" + sDate + "'";
            DataSet ds = null;
            string ErrMessage = "";
            if (DBAccess.ExecSql(strSql, ref ds, ref ErrMessage) == 0)
            {
                //oRpt.Load(Application.StartupPath + " crtDay1.rpt");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        string weekDate = null;
                        weekDate = ds.Tables[0].Rows[i]["WeekDate"].ToString();
                        //string[] arry = new string[7] { "Moday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"};
                        switch (weekDate)
                        {
                            case "Moday":
                                weekDate = "星期一";
                                break;
                            case "Tuesday":
                                weekDate = "星期二";
                                break;
                            case "Wednesday":
                                weekDate = "星期三";
                                break;
                            case "Thursday":
                                weekDate = "星期四";
                                break;
                            case "Friday":
                                weekDate = "星期五";
                                break;
                            case "Saturday":
                                weekDate = "星期六";
                                break;
                            case "Sunday":
                                weekDate = "星期天";
                                break;
                            default:
                                weekDate = ds.Tables[0].Rows[i]["WeekDate"].ToString();
                                break;
                        }
                        int Abnormity=0;
                        string abnormity = null;
                        switch(Abnormity)
                        {
                            case 0:
                                abnormity = "正常";
                                break;
                            case 1:
                                abnormity = "迟到";
                                break;
                            case 2:
                                abnormity = "早退";
                                break;
                            default:
                                abnormity = "正常";
                                break;
                        }
                        string  OnDutyDay = Convert.ToDateTime(ds.Tables[0].Rows[i]["OnDutyDay"]).ToShortDateString();
                        //DateTime UpPassTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["UpPassTime"]).ToLongTimeString();
                        //DateTime OffPassTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["OffPassTime"]).ToLongTimeString();
                        oRpt.ParameterFields["职工工号"].CurrentValues.AddValue(ds.Tables[0].Rows[i]["Code"].ToString());
                        oRpt.ParameterFields["职工姓名"].CurrentValues.AddValue(ds.Tables[0].Rows[i]["Name"].ToString());
                        oRpt.ParameterFields["日期"].CurrentValues.AddValue(OnDutyDay.ToString());
                        oRpt.ParameterFields["星期"].CurrentValues.AddValue(weekDate);
                        oRpt.ParameterFields["进时间"].CurrentValues.AddValue(ds.Tables[0].Rows[i]["UpPassTime"].ToString());
                        oRpt.ParameterFields["出时间"].CurrentValues.AddValue(ds.Tables[0].Rows[i]["OffPassTime"].ToString());
                        oRpt.ParameterFields["迟到时间"].CurrentValues.AddValue(ds.Tables[0].Rows[i]["LateDuty"].ToString());
                        oRpt.ParameterFields["早退时间"].CurrentValues.AddValue(ds.Tables[0].Rows[i]["EarlyDuty"].ToString());
                        oRpt.ParameterFields["状态"].CurrentValues.AddValue(abnormity);
                        oRpt.ParameterFields["加班"].CurrentValues.AddValue(ds.Tables[0].Rows[i]["OT"].ToString());
                        //oRpt.SetDataSource(ds);
                        
                    }
                    this.crystalReportViewer1.ReportSource = oRpt;
                }
                else
                {
                    this.crystalReportViewer1.Visible = false;                }
            }//首先从数据库中能查出3条记录:
但是现在问题是循环3次后报表上只是显示第一条记录
不知道什么原因有谁知道吗

Answer 1

又不是DataRow 是参数字段啊！

Answer 2

DataRow数据是一条一条的也就是说可以有多条参数字段就是变量，一个变量只能有一个值啊

Answer 3

DataRow数据是一条一条的也就是说可以有多条参数字段就是变量，一个变量只能有一个值啊这个你刚刚不是说了吗?????
现在问题是怎么做呢?

Answer 4

在本地建立一个DataTable 让后把数据循环的读入这个DataTable中，然后把这个DataTable
放入一个DataSet中，在绑定给报表
难道你没有用.xsd么？
为什么要用参数字段啊！

Answer 5

dp.CommandText = "SELECT * WHERE (c.FBaseInfoID = @FBaseInfoID)";//定义查询
dp.Parameter.Add("FBaseInfoID",user.userID);
DataSet ds1 = dp.DataSetSQL();//将查询结果返回到DataSet中 
R_C102 R_D_C102 = new R_C102(); //定义报表事例控件用于绑定数据,没创建一个报表文件就是创建了一个报表文件类
R_D_C102.SetDataSource(ds1); //将数据(ds1)绑定到报表文件上   
CrystalReportViewer1.ReportSource = R_D_C102;
CrystalReportViewer1.DataBind();
--------------------------------
如果你想改变 ds1的Table中的值你循环变例修改就可以了
例如
for(int i=0;i<ds1.Tables[0].rows.count;i++)
{
  if (ds1.Tables[0].rows[i]["星期"].tostring() == 1)
        {
         ds1.Tables[0].rows[i]["星期"]="星期一";
         }
           ....
}

Answer 6

没有用xsd
一定要用那个吗
2005下要用么
第一次接触这个东西