private void btnAttendanceBetweenReport_Click(object sender, EventArgs e) { if (dataGridView1.RowCount > 0) { DataSet ds = Connection.GetDataSet(" SELECT schoolname, schooladdress, affiliate_by, logoimage FROM tbl_school"); DataTable dt = Connection.GetDataTableFromDataGridView(dataGridView1); DataView dv = Connection.GetDataSet("Select EmpNo,EmpName,AccountNo,BankName From tbl_EmployeeInfo").Tables[0].DefaultView; dt.Columns.Add("AccountNo"); dt.Columns.Add("BankName"); for (int i = 0; i < dt.Rows.Count; i++) { dv.RowFilter = "EmpNo =" + dt.Rows[i][0]; dt.Rows[i]["AccountNo"] = dv[0][2]; dt.Rows[i]["BankName"] = dv[0][3]; } ds.Tables.Add(dt); rptSalaryStatementForBank cr1 = new rptSalaryStatementForBank(); cr1.PrintOptions.PaperOrientation = PaperOrientation.Portrait; cr1.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter; ds.WriteXmlSchema(@"" + Connection.GetAccessPathId() + @"Barcodes\a\SalaryStatementForBank.xsd"); cr1.SetDataSource(ds); cr1.SetParameterValue("Month", new DateTime(Convert.ToInt16(cmbYear.Text), cmbMonth.SelectedIndex, 1)); ShowAllReports s = new ShowAllReports(); s.crystalReportViewer1.ReportSource = cr1; s.Show(); } else { MessageBox.Show("Record Not Shown.\n\tPlease Select Month And Press Tab Key."); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptSalaryStatementForBank rpt = new rptSalaryStatementForBank(); rpt.Site = this.Site; return(rpt); }