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);
}
