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