public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { EmployeeRpt2 rpt = new EmployeeRpt2(); rpt.Site = this.Site; return(rpt); }
private void button1_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() + "' and (VALID_TO between '" + dateTimePickerValid.Text + "' and '" + dateTimePickervalidTo.Text + "') "; } 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 FROM EMPLOYEE_CARDS " + FilterString + " order by CRD_NAME"; DataTable dt = new DataTable(); SqlDataAdapter _da = new SqlDataAdapter(cmd); _da.Fill(dt); frmReportViewer2 Viewer = new frmReportViewer2(); EmployeeRpt2 rpt = new EmployeeRpt2(); rpt.Database.Tables[0].SetDataSource(dt); Viewer.crystalReportViewer1.ReportSource = rpt; Viewer.ShowDialog(); this.Close(); }