public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptDueFee rpt = new rptDueFee();
rpt.Site = this.Site;
return(rpt);
}
public override void btnprint_Click(object sender, EventArgs e)
{
if (dataGridView1.RowCount > 0)
{
if (ChkIdDueGreater.Checked)
{
if (chkClassWise.Checked == true && chkSection.Checked == false)
{
DataView dv = dtTotalFee.DefaultView;
dv.RowFilter = "ClassNo='" + cmbClass.SelectedValue + "' And SessionCode='" + cmbSession.SelectedValue + "' and [Due Fee]>0";
dv.Sort = "Name";
dataGridView1.DataSource = dv;
}
else if (chkClassWise.Checked == true && chkSection.Checked == true)
{
DataView dv = dtTotalFee.DefaultView;
dv.RowFilter = "ClassNo='" + cmbClass.SelectedValue + "' And SessionCode='" + cmbSession.SelectedValue + "' And SectionNo='" + cmbSection.SelectedValue + "' and [Due Fee]>0";
dv.Sort = "Name";
dataGridView1.DataSource = dv;
}
else
{
DataView dv = dtTotalFee.DefaultView;
dv.RowFilter = "[Due Fee]>0";
dv.Sort = "Name";
dataGridView1.DataSource = dv;
}
}
DataSet ds = Connection.GetDataSet("SELECT schoolname, schooladdress, schoolcity, schoolphone, affiliate_by, principal, registrationno, logoimage From tbl_school");
ds.Tables.Add(Connection.GetDataTableFromDataGridView(dataGridView1));
ds.WriteXmlSchema(@"" + Connection.GetAccessPathId() + @"Barcodes\a\DueFee.xsd");
rptDueFee fr1 = new rptDueFee();
fr1.PrintOptions.PaperOrientation = PaperOrientation.Portrait;
fr1.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetter;
fr1.SetDataSource(ds);
ShowAllReports s1 = new ShowAllReports();
s1.crystalReportViewer1.ReportSource = fr1;
fr1.SetParameterValue("Session", cmbSession.Text);
if (chkClassWise.Checked && !chkClassWise.Checked)
{
fr1.SetParameterValue("ReportTitle", cmbStudentStatus.Text + " Due Fee Detail For Class - " + cmbClass.Text.Trim());
}
else if (chkClassWise.Checked && chkSection.Checked)
{
fr1.SetParameterValue("ReportTitle", cmbStudentStatus.Text + " Due Fee Detail For Class - " + cmbClass.Text.Trim() + " " + cmbSection.Text.Trim());
}
else
{
fr1.SetParameterValue("ReportTitle", cmbStudentStatus.Text + " Due Fee Detail");
}
s1.Show();
}
}