水晶报表dataset与参数传值的设置

     string str_select = "select * from xt_depart_kkb where months='" + m_mmonths + "'and xxly like'%" + m_ddepartment + "%'or xxly='各单位' or xxly ='各车间'or xxly ='各部门' order by fz desc";
            SqlConnection conn = pbvar.getconn();
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter(str_select, conn);
            data.datasetprint dataprint = new kksystem.data.datasetprint();//dataset
            sda.Fill(dataprint, "xt_Depart_Kkb");
            crotherdepart crpt = new crotherdepart();
            crpt.SetDataSource(dataprint);
            crpt.SetParameterValue("departname", m_ddepartment);//给水晶报表中的参数传值
            crystalReportViewer1.ReportSource = crpt;