private void barButtonItem5_ItemClick_1(object sender, ItemClickEventArgs e)
{
var numbers = Database.Query("learner_details", "Division = '" + GlobalProperties.loggedOnUserDivison + "' AND NOT SecNumber =''");
if (numbers.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No Security Numbers found for this college");
return;
}
var report = new rptSecNum();
report.SetDataSource(numbers);
report.DataDefinition.FormulaFields["Division"].Text = "\"" + GlobalProperties.LoggedOnUserDivision + "\"";
var frmReport = new frmReport(report) { Text = "Security Numbers" };
frmReport.ShowDialog();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptSecNum rpt = new rptSecNum();
rpt.Site = this.Site;
return rpt;
}