private void fillreport() { if (txtfromDate.Text != "" && txttoDate.Text != "" && txtcustomer.Text != "") { 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_SpecimenDetailsForInvoice_Customerwise((txtcustomer.Text), Convert.ToDateTime(from), Convert.ToDateTime(To)).Tables[0]; // dt = Specimen.Get_SpecimenDetailsForInvoice().Tables[0]; if (dt.Rows.Count > 0) { ReportDocument crystalReport = new ReportDocument(); crystalReport.Load(Server.MapPath("Report/CustomerWiseReport.rpt")); crystalReport.SetDataSource(dt); crtcustomer.ReportSource = crystalReport; } else { MessageBox("Records Not Found"); txtcustomer.Focus(); } } catch { } } } }