public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { EmployeeRptALL rpt = new EmployeeRptALL(); rpt.Site = this.Site; return(rpt); }
private void button2_Click(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(); cmd.CommandTimeout = 2000; cmd.Connection = frmMainForm._MasterCon; string FilterString = ""; bool FilterFlag = false; string inFilter = ""; if (cmbLocation.SelectedItem != null) { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " LOCATION ='" + cmbLocation.SelectedItem.ToString() + "' "; } if (cmbCompany.SelectedItem != null) { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " COMPANY = '" + cmbCompany.SelectedItem.ToString() + "' "; } if (cmbDep.SelectedValue.ToString() != "") { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + "CRD_DEPARTMENT = '" + cmbDep.SelectedValue.ToString() + "'"; } if (cmb_permit.SelectedValue.ToString() != "") { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " PERMITION = '" + cmb_permit.SelectedValue.ToString() + "'"; } if (cmb_status.SelectedValue.ToString() != "") { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " STATUS = '" + cmb_permit.SelectedValue.ToString() + "'"; } if (checkBox1.Checked) { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " IN_JOB = 1"; } if (!checkBox1.Checked) { string initalFilter = ""; if (!FilterFlag) { initalFilter = " where "; FilterFlag = true; } else { initalFilter = " and "; } FilterString += initalFilter + " IN_JOB = 0"; } inFilter = ""; if (!FilterFlag) { inFilter = " where "; FilterFlag = true; } else { inFilter = " and "; } FilterString += inFilter + " CRD_NAME NOT LIKE '%V' "; cmd.CommandText = "SELECT EMPLOYEE_CARDS.CRD_NO, EMPLOYEE_CARDS.CRD_NAME, EMPLOYEE_CARDS.CRD_STARTING_DATE, EMPLOYEE_CARDS.CRD_EXPIRY_DATE, EMPLOYEE_CARDS.CRD_JOB, EMPLOYEE_CARDS.CRD_LAST_TRANSACTION_TYPE, EMPLOYEE_CARDS.CRD_DEPARTMENT,EMPLOYEE_CARDS.LOCATION,EMPLOYEE_CARDS.COMPANY,AR_NAME,ADDRESS,NATIONAL_ID,PHONE,STATUS,PERMITION,VALID_TO,AR_JOB,AR_DEP,STATUS_DATE FROM EMPLOYEE_CARDS " + FilterString + " order by CRD_NAME"; DataTable dt = new DataTable(); SqlDataAdapter _da = new SqlDataAdapter(cmd); _da.Fill(dt); frmReportViewer2 Viewer = new frmReportViewer2(); EmployeeRptALL rpt = new EmployeeRptALL(); rpt.Database.Tables[0].SetDataSource(dt); Viewer.crystalReportViewer1.ReportSource = rpt; Viewer.ShowDialog(); this.Close(); }