public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
guard_single_report rpt = new guard_single_report();
rpt.Site = this.Site;
return(rpt);
}
private void frmcrystal_report_single_Load(object sender, EventArgs e)
{
if (SystemConst._Single_report_type == "Active")
{
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
guard_single_report report = new guard_single_report();
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(sg_Reports.RETURN_OFFICER_DETAILS("", SystemConst.guard_number));
report.SetParameterValue("QueryName", "SELECT_GUARD_REPORT_SINGLE");
report.SetParameterValue("guard_number", SystemConst.guard_number);
report.SetParameterValue("guard_status", String.Empty);
report.SetParameterValue("client_name", SystemConst.ClientName);
crystalReportViewer1.ParameterFieldInfo = paramFields;
this.crystalReportViewer1.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
else if (SystemConst._Single_report_type == "Archieve")
{
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
guard_single_report report = new guard_single_report();
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(sg_Reports.RETURN_OFFICER_DETAILS("", SystemConst.guard_number));
report.SetParameterValue("QueryName", "SELECT_ARCHIEVED_GUARD_REPORT_SINGLE");
report.SetParameterValue("guard_number", SystemConst.guard_number);
report.SetParameterValue("guard_status", String.Empty);
report.SetParameterValue("client_name", SystemConst.ClientName);
crystalReportViewer1.ParameterFieldInfo = paramFields;
this.crystalReportViewer1.ReportSource = report;
//this.crystalReportViewer1.RefreshReport();
}
}
