public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crpReport rpt = new crpReport();
rpt.Site = this.Site;
return(rpt);
}
private void btn_report_Click(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter("select s.adno AS [Admission No],s.sname AS [Student Name],s.Newsyll AS Syllabus,d.cstandard AS Standard,d.Division from tbl_class c INNER JOIN tbl_stddivision d ON c.classno=d.classno INNER JOIN tbl_student s ON d.adno=s.adno ", d.con);
DataSet ds = new DataSet();
da.Fill(ds);
DataRow dr;
if (ds.Tables[0].Rows.Count > 0)
{
dr = ds.Tables[0].Rows[0];
crpReport crs = new crpReport();
crs.SetDataSource(ds.Tables[0]);
crpviewer1.ReportSource = crs;
crpviewer1.Refresh();
}
}
private void btn_RPT_Click(object sender, EventArgs e)
{
SqlDataAdapter da = new SqlDataAdapter("Select sub.subjectnum AS [Subject No],s.Newsyll AS Syllabus,c.cstandard AS Standard,c.division AS Division,sub.subject AS Subject from tbl_class c INNER JOIN tbl_syllabus s ON c.syllabusnum=s.syllabusnum INNER JOIN tbl_syllabusinstandard ss ON s.syllabusnum=ss.syllabusnum INNER JOIN tbl_subject sub ON ss.subjectnum=sub.subjectnum", d.con);
DataSet ds = new DataSet();
DataRow dr;
da.Fill(ds);
if (ds.Tables[0].Rows.Count >= 1)
{
dr = ds.Tables[0].Rows[0];
crpReport crp = new crpReport();
crp.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = crp;
crystalReportViewer1.Refresh();
}
//sub.subjectnum AS [Subject No],s.Newsyll AS Syllabus,c.cstandard AS Standard,c.division AS Division,sub.subject AS Subject from tbl_class c INNER JOIN tbl_syllabus s ON c.syllabusnum=s.syllabusnum INNER JOIN tbl_syllabusinstandard ss ON s.syllabusnum=ss.syllabusnum INNER JOIN tbl_subject sub ON ss.subjectnum=sub.subjectnum
}
