private void salesmanfillreport() { if (txtfromDate.Text != "" && txttoDate.Text != "" && DDLSalesman.SelectedItem.Value != "") { string from = txtfromDate.Text.Split('/')[1] + "/" + txtfromDate.Text.Split('/')[0] + "/" + txtfromDate.Text.Split('/')[2]; string To = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2]; fdate = Convert.ToDateTime(from); tdate = Convert.ToDateTime(To); if (fdate > tdate) { MessageBox("From Date is Greater than ToDate"); txtfromDate.Focus(); } else { try { DataTable dt = new DataTable(); dt = Specimen.Get_SalesmanWiseBooks(DDLSalesman.SelectedItem.Value.ToString(), Convert.ToDateTime(from), Convert.ToDateTime(To)).Tables[0]; ReportDocument CR = new ReportDocument(); CR.Load(Server.MapPath("Report/SalesmanWiseBooks.rpt")); CR.SetDataSource(dt); crystalreportviewer1.ReportSource = CR; } catch {} } } }