public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
classwisesubject rpt = new classwisesubject();
rpt.Site = this.Site;
return(rpt);
}
public override void btnprint_Click(object sender, EventArgs e)
{
DataSet ds = Connection.GetDataSet("SELECT tbl_subwiseclass.board, tbl_subwiseclass.subjecttype, tbl_subject.subjectname, tbl_subwiseclass.sankayname, tbl_school.schoolname, tbl_school.schooladdress, tbl_school.logoimage,tbl_school.affiliate_by, tbl_classmaster.classname FROM tbl_subject INNER JOIN tbl_subwiseclass ON tbl_subject.subjectno = tbl_subwiseclass.subjectno INNER JOIN tbl_school ON tbl_subwiseclass.board = tbl_school.affiliate_by INNER JOIN tbl_classmaster ON tbl_subwiseclass.classno = tbl_classmaster.classcode WHERE (tbl_subwiseclass.classno = '" + classno + "') order by tbl_subwiseclass.subjecttype ");
if (ds != null)
{
// ds.WriteXmlSchema(@"D:\Barcodes\a\classwisesubject.xsd");
classwisesubject fr = new classwisesubject();
fr.SetDataSource(ds);
ShowAllReports s = new ShowAllReports();
s.crystalReportViewer1.ReportSource = fr;
s.Show();
}
}
