public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReportStudentReportForm rpt = new CrystalReportStudentReportForm(); rpt.Site = this.Site; return(rpt); }
private void crystalReportViewer1_Load(object sender, EventArgs e) { string s = "SELECT s.sname, s.sfname, a.classno, a.cstandard, c.division, s.Newsyll, e.Grade, e.mark, sb.subject, em.exam FROM tbl_student AS s INNER JOIN tbl_attend AS a ON s.adno = a.adno INNER JOIN tbl_class AS c ON a.classno = c.classno INNER JOIN tbl_ExamResult AS e ON c.classno = e.stdno INNER JOIN tbl_subject AS sb ON e.subno = sb.subjectnum INNER JOIN tbl_exam AS em ON e.examno = em.examnum where a.adno=" + SchoolManagement.adno + "AND e.examno = " + SchoolManagement.exmno + " "; 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]; CrystalReportStudentReportForm crpf = new CrystalReportStudentReportForm(); crpf.SetDataSource(ds.Tables[0]); crystalReportViewer1.ReportSource = crpf; crystalReportViewer1.Refresh(); } }