protected void Load_Report() { this.WindowState = System.Windows.Forms.FormWindowState.Maximized; guard_employment_record_report report = new guard_employment_record_report(); ParameterFields paramFields = new ParameterFields(); ParameterField paramField = new ParameterField(); ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); //set report connection details //ConnectionInfo myconnectioninfo = new ConnectionInfo(); //myconnectioninfo.ServerName = "Thadeous"; //myconnectioninfo.DatabaseName = "guard_profiles_db"; //myconnectioninfo.UserID = "sg_admin"; //myconnectioninfo.Password = "******"; //SET_CONNECTION_INFO(myconnectioninfo); foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } //report.SetDataSource(sg_Reports.RETURN_OFFICER_DETAILS("", SystemConst.guard_number)); report.SetParameterValue("QueryName", "SELECT_GUARD_EMPLOYMENT_RECORD_REPORT"); report.SetParameterValue("guard_number", SystemConst.guard_number); employment_report_reportviewer.ParameterFieldInfo = paramFields; this.employment_report_reportviewer.ReportSource = report; //this.crystalReportViewer1.RefreshReport(); }
protected void Load_Report() { base.WindowState = FormWindowState.Maximized; guard_employment_record_report report = new guard_employment_record_report(); ParameterFields paramFields = new ParameterFields(); ParameterField parameterField = new ParameterField(); ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue(); foreach (Table tbCurrent in report.Database.Tables) { Set_Report_logons.SetTableLogin(tbCurrent); } report.SetParameterValue("QueryName", "SELECT_GUARD_EMPLOYMENT_RECORD_REPORT"); report.SetParameterValue("guard_number", SystemConst.guard_number); this.employment_report_reportviewer.ParameterFieldInfo = paramFields; this.employment_report_reportviewer.ReportSource = report; }