public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { R_Landbade_MER rpt = new R_Landbade_MER(); rpt.Site = this.Site; return(rpt); }
public void Load_MER() { Cursor.Current = Cursors.WaitCursor; wizard1.SelectedTab = tabPage4; tabControl1.SelectedTab = tabPage5; IniFile ini = new IniFile(ClassSql.MMS_Path); DataClasses1DataContext db = new DataClasses1DataContext(Properties.Settings.Default.MyConString); DataTable dt = new ds_report2.sp_Landbase_MER1DataTable(); R_Landbade_MER R_Landbase_MER = new R_Landbade_MER(); var list = db.sp_Landbase_MER1(this.Tag.ToString()).ToList(); foreach (var i in list) { dt.Rows.Add( i.lastname, i.firstname, i.middlename, i.address_1, i.position, i.marital_status, i.gender, i.birthdate, i.place_of_birth, i.employer, i.passport_no, i.nationality, i.religion, i.country_destination, i.picture.ToArray(), i.resultid, i.head_injury, i.frequent_headaches, i.frequent_dizziness, i.fainting_spells, i.insomnia, i.depression, i.trachoma, i.deafness, i.nose_throat_disorder, i.tuberculosis, i.other_lung_disorder, i.high_blood_pressure, i.heart_disease, i.rheumatic_fever, i.diabetes_mellitus, i.other_endocrine_disorder, i.cancer_tumor, i.blood_disorders, i.stomach_pain, i.other_abdominal_disorder, i.kidney_bladder_disorder, i.back_injury, i.genetic_hereditary, i.sexually_transmit_disease, i.tropical_disease, i.asthma, i.allergies, i.gynecological_disorder, i.operations, i.operations_specify, i.others, i.schistosomiasis, i.last_menstrual_period, i.allergies_specify, i.other_abdominal_specify, i.column1, i.column2, i.column3, i.column4, i.column5, i.column6, i.column7, i.column7_comment, i.column8, i.column8_comment, i.column1_comment, i.column2_comment, i.column3_comment, i.column4_comment, i.column5_comment, i.column6_comment); } R_Landbase_MER.SetDataSource(dt); TextObject FormNo = (TextObject)R_Landbase_MER.ReportDefinition.ReportObjects["txt_formNo"]; TextObject RevNo = (TextObject)R_Landbase_MER.ReportDefinition.ReportObjects["txt_RevNo"]; TextObject Iso = (TextObject)R_Landbase_MER.ReportDefinition.ReportObjects["txt_iso"]; FormNo.Text = ini.IniReadValue("FORM", "Landbase_MER"); RevNo.Text = ini.IniReadValue("REVISION", "Landbase_MER"); Iso.Text = ini.IniReadValue("ISO", "Landbase_MER"); Viewer4_1.ReportSource = R_Landbase_MER; RemoveTab(Viewer4_1); Cursor.Current = Cursors.Default; }