private void crystalReportViewer1_Load(object sender, EventArgs e)
{
double a = 0;
string s = "SELECT bt.TransactionNo,ba.BankName, ba.IFSCCode, bt.Amount, bt.Balance, bt.Type, bt.TransactionDate FROM tbl_Bankadrs AS ba INNER JOIN tbl_BankTran AS bt ON ba.AccountNumber = bt.BankAccNo WHERE TransactionDate >='" + SchoolManagement.dtpb1 + "'AND bt.TransactionDate <='" + SchoolManagement.dtpb2 + "'AND bt.BankAccNo='" + SchoolManagement.accno + "' ORDER BY bt.TransactionDate DESC ";
SqlDataAdapter da = new SqlDataAdapter(s, d.con);
DataSet ds = new DataSet();
DataRow dr;
da.Fill(ds);
if (ds.Tables[0].Rows.Count >= 1)
{
string s1 = "SELECT TOP (1) TransactionNo,Balance FROM tbl_BankTran WHERE BankAccNo ='" + SchoolManagement.accno + "' ORDER BY TransactionNo DESC";
SqlDataAdapter da1 = new SqlDataAdapter(s1, d.con);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
DataRow dr1;
if (ds1.Tables[0].Rows.Count >= 1)
{
dr1 = ds1.Tables[0].Rows[0];
a = Convert.ToDouble(dr1[1].ToString());
}
dr = ds.Tables[0].Rows[0];
crpbanktrans crp = new crpbanktrans();
crp.SetDataSource(ds.Tables[0]);
crp.SetParameterValue("closingblnc", a);
crp.SetParameterValue("accno", SchoolManagement.accno);
crp.SetParameterValue("startdate", SchoolManagement.dtpb1);
crp.SetParameterValue("enddate", SchoolManagement.dtpb2);
crystalReportViewer1.ReportSource = crp;
crystalReportViewer1.Refresh();
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crpbanktrans rpt = new crpbanktrans();
rpt.Site = this.Site;
return(rpt);
}