public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
reportLoans rpt = new reportLoans();
rpt.Site = this.Site;
return(rpt);
}
private void ReportLoans_Load(object sender, EventArgs e)
{
reportLoans report = new reportLoans();
OleDbConnection myDb = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Stokvel Database.accdb");
DataSet ds = new DataSet();
OleDbDataAdapter myAdapter = new OleDbDataAdapter(@"SELECT * FROM Loans ", myDb);
myAdapter.Fill(ds, "Loans");
report.SetDataSource(ds.Tables["Loans"]);
txtSummart.Text = Class1.MemberID;
crystalReportViewer1.SelectionFormula = "{Loans.MembershipID}='" + txtSummart.Text + "'";
crystalReportViewer1.ReportSource = report;
crystalReportViewer1.RefreshReport();
crystalReportViewer1.Refresh();
}
