public void BindCrist() { if (txtfromDate.Text != "" || txttoDate.Text != "") { if (txtBook.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]; string BookCode = txtBook.Text.Split(':')[0].Trim(); string bookCode2 = "null"; // bookname = txtBook.Text.Split(':')[2].Trim(); fdate = Convert.ToDateTime(from); tdate = Convert.ToDateTime(To); if (fdate > tdate) { MessageBox("From Date is Greater than ToDate"); txtfromDate.Focus(); } else { DataTable dt = new DataTable(); dt = Specimen.Get_SpecimenDetailsForInvoice_Bookwise(bookCode2, BookCode, Convert.ToDateTime(from), Convert.ToDateTime(To)).Tables[0]; ReportDocument CR = new ReportDocument(); CR.Load(Server.MapPath("Report/BookWiseReport.rpt")); cryBookwise.SeparatePages = false; CR.SetDataSource(dt); cryBookwise.ReportSource = CR; } } else { 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]; string BookCode = "null"; //txtBook.Text.Split(':')[0].Trim(); string bookCode2 = "null"; // bookname = txtBook.Text.Split(':')[2].Trim(); fdate = Convert.ToDateTime(from); tdate = Convert.ToDateTime(To); if (fdate > tdate) { MessageBox("From Date is Greater than ToDate"); txtfromDate.Focus(); } else { DataTable dt = new DataTable(); dt = Specimen.Get_SpecimenDetailsForInvoice_Bookwise(bookCode2, BookCode, Convert.ToDateTime(from), Convert.ToDateTime(To)).Tables[0]; ReportDocument CR = new ReportDocument(); CR.Load(Server.MapPath("Report/BookWiseReport.rpt")); cryBookwise.SeparatePages = false; CR.SetDataSource(dt); cryBookwise.ReportSource = CR; } } } }