private void frm_archieved_guard_list_report_Load(object sender, EventArgs e)
{
string _guard_status = SystemConst._guard_status;
if (_guard_status != String.Empty)
{
try {
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
cr_archived_guard_lists report = new cr_archived_guard_lists();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
foreach (CrystalDecisions.CrystalReports.Engine.Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Archieve_Lists.SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS("SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS", _guard_status));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS");
report.SetParameterValue("guard_status", SystemConst._guard_status);
cr_viewer_archieved_guards_report.ParameterFieldInfo = paramFields;
this.cr_viewer_archieved_guards_report.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
catch (Exception ex) {
throw ex;
}
}
else
{
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
cr_archived_guard_lists report = new cr_archived_guard_lists();
ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
report.SetDatabaseLogon("sg_admin", "sg_admin123"); //hide the password from the code..get it from configuration file...
report.SetDataSource(Archieve_Lists.SELECT_ARCHIEVED_GUARD_LIST_ALL("SELECT_ARCHIEVED_GUARD_LIST_ALL"));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_LIST_ALL");
// report.SetParameterValue("guard_status", SystemConst._guard_status);
cr_viewer_archieved_guards_report.ParameterFieldInfo = paramFields;
this.cr_viewer_archieved_guards_report.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
}
private void frm_archieved_guard_list_report_Load(object sender, EventArgs e)
{
string _guard_status = SystemConst._guard_status;
if (_guard_status == string.Empty)
{
base.WindowState = FormWindowState.Maximized;
cr_archived_guard_lists report = new cr_archived_guard_lists();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField1 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Archieve_Lists.SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS("SELECT_ARCHIEVED_GUARD_LIST_ALL", _guard_status));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_LIST_ALL");
report.SetParameterValue("guard_status", SystemConst._guard_status);
report.SetParameterValue("client_name", SystemConst.ClientName);
this.cr_viewer_archieved_guards_report.ParameterFieldInfo = paramFields;
this.cr_viewer_archieved_guards_report.ReportSource = report;
}
else
{
try
{
base.WindowState = FormWindowState.Maximized;
cr_archived_guard_lists report = new cr_archived_guard_lists();
ParameterFields paramFields = new ParameterFields();
ParameterField parameterField1 = new ParameterField();
ParameterDiscreteValue parameterDiscreteValue1 = new ParameterDiscreteValue();
foreach (Table tbCurrent in report.Database.Tables)
{
Set_Report_logons.SetTableLogin(tbCurrent);
}
report.SetDataSource(Archieve_Lists.SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS("SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS", _guard_status));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_LIST_REPORT_BY_STATUS");
report.SetParameterValue("guard_status", SystemConst._guard_status);
this.cr_viewer_archieved_guards_report.ParameterFieldInfo = paramFields;
this.cr_viewer_archieved_guards_report.ReportSource = report;
}
catch (Exception exception)
{
throw exception;
}
}
}
