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