private void specimenfillreport() { if (txtDocno.Text != "" && DDLsubconfirmid.SelectedItem.Value != "") { if (txtDocno.Text.ToString() == "") { MessageBox("Require Document No."); } try { DataTable dt = new DataTable(); dt = Specimen.Get_SpecimenDetailsForInvoice(Convert.ToInt32(txtDocno.Text.ToString()), Convert.ToDecimal(DDLsubconfirmid.SelectedItem.Value.ToString())).Tables[0]; if (dt.Rows.Count > 0) { ReportDocument CR = new ReportDocument(); CR.Load(Server.MapPath("Report/SpecimenReport.rpt")); CR.SetDataSource(dt); crtspecimen.ReportSource = CR; } //else //{ // MessageBox("No Records Found"); // txtDocno.Focus(); //} } catch { } } }
protected void Button1_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = Specimen.Get_SpecimenDetailsForInvoice(Convert.ToInt32(TextBox1.Text), Convert.ToDecimal("1.01")).Tables[0]; // dt = Specimen.Get_SpecimenDetailsForInvoice().Tables[0]; ReportDocument crystalReport = new ReportDocument(); crystalReport.Load(Server.MapPath("Report/SpecimenReport.rpt")); crystalReport.SetDataSource(dt); CrystalReportViewer1.ReportSource = crystalReport; }