public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            CrystalReportAccountfee rpt = new CrystalReportAccountfee();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void crystalReportViewer1_Load(object sender, EventArgs e)
        {
            SqlDataAdapter da = new SqlDataAdapter("select s.adno as [AdNo:],s.sname as [Name],st.cstandard as [Standard],st.division as [Division],'TutionFee' as [FeeType],tp.Amount from tbl_student s join tbl_stddivision st on s.adno=st.adno join tbl_tutionfeepayment tp on tp.adno=s.adno", d.con);
            DataSet        ds = new DataSet();

            da.Fill(ds);
            CrystalReportAccountfee crp1 = new CrystalReportAccountfee();

            crp1.SetDataSource(ds.Tables[0]);
            crystalReportViewer1.ReportSource = crp1;
            crystalReportViewer1.Refresh();

            /* string s = "Select s.";
             * SqlDataAdapter da = new SqlDataAdapter(s, d.con);
             * DataSet ds = new DataSet();
             * DataRow dr;
             * da.Fill(ds);
             * if (ds.Tables[0].Rows.Count >= 1)
             * {
             *   dr = ds.Tables[0].Rows[0];
             *
             *   CrystalReportAccountfee crp1 = new CrystalReportAccountfee();
             *   crp1.SetDataSource(ds.Tables[0]);
             *   crp1.SetParameterValue("startdate", SchoolManagement.dtp1);
             *   crp1.SetParameterValue("enddate", SchoolManagement.dtp2);
             *   crystalReportViewer1.ReportSource = crp1;
             *   crystalReportViewer1.Refresh();
             *
             * }*/
        }