public void Load_mlc() { //Summary = false; Detail = false; MER = false; MLC1 = true ; MLC2 = false; R_Seabase_MLC1.Load(@"C:\Report\R_Seabase_MLC.rpt"); crystalReportViewer2.ReportSource = R_Seabase_MLC1; crystalReportViewer2.SelectionFormula = "{t_result_main1.resultid} = '" + this.Tag.ToString() + "'"; ClassSql a = new ClassSql(); TextBox txt_ForNo = new TextBox(); TextBox txt_RevNo = new TextBox(); a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '14'", txt_ForNo, "Form"); a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '14'", txt_RevNo, "Revision"); TextObject FormNo = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_formNo"]; TextObject RevNo = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_RevNo"]; TextObject CompanyName = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_CompanyName"]; TextObject CompanyAdd = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_CompanyAdd"]; FormNo.Text = txt_ForNo.Text; RevNo.Text = txt_RevNo.Text; CompanyName.Text = Properties.Settings.Default.CompanyName.ToString(); CompanyAdd.Text = Properties.Settings.Default.CompanyAdd.ToString(); //R_Seabase_MLC1.Refresh(); crystalReportViewer2.RefreshReport(); RemoveTab(crystalReportViewer2); wizard1.SelectedTab = tabPage2; }
void Load_MLC() { this.Text = "Seafarer's Medical Examination Certificate Print-Out"; R_Seabase_MLC1.Load(@"C:\Report\R_Seabase_MLC.rpt"); crystalReportViewer1.ReportSource = R_Seabase_MLC1; crystalReportViewer1.SelectionFormula = "{t_result_main1.resultid} = '" + this.Tag.ToString() + "'"; ClassSql a = new ClassSql(); TextBox txt_ForNo = new TextBox(); TextBox txt_RevNo = new TextBox(); a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '14'", txt_ForNo, "Form"); a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '14'", txt_RevNo, "Revision"); TextObject FormNo = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_formNo"]; TextObject RevNo = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_RevNo"]; //TextObject CompanyName = (TextObject)R_Seabase_Summary1.ReportDefinition.ReportObjects["txt_CompanyName"]; //TextObject CompanyAdd = (TextObject)R_Seabase_Summary1.ReportDefinition.ReportObjects["txt_CompanyAdd"]; FormNo.Text = txt_ForNo.Text; RevNo.Text = txt_RevNo.Text; //CompanyName.Text = Properties.Settings.Default.CompanyName.ToString(); //CompanyAdd.Text = Properties.Settings.Default.CompanyAdd.ToString(); // R_Seabase_MLC1.Refresh(); crystalReportViewer1.RefreshReport(); RemoveTab(crystalReportViewer1); // wizard1.SelectedTab = tabPage1; }
private void button2_Click(object sender, EventArgs e) { R_Seabase_MLC1.PrintOptions.PrinterName = Tool.PrinterPath(); R_Seabase_MLC1.PrintToPrinter(1, false, 0, 0); }