void LoadStudents()
{
oReports = new DataAccess.Reports();
ReportViewer.LocalReport.ReportPath = sReportPath + sReportName;
ReportViewer.LocalReport.DataSources.Clear();
ReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ReportDataSet", oReports.GetStudents(dtDateFrom.Value, dtDateTo.Value)));
ReportViewer.SetDisplayMode(DisplayMode.PrintLayout);
ReportViewer.ZoomMode = ZoomMode.Percent;
ReportViewer.ZoomPercent = 100;
ReportViewer.RefreshReport();
}
void VoteResult()
{
oReports = new DataAccess.Reports();
ReportViewer.LocalReport.ReportPath = sReportPath + sReportName;
ReportViewer.LocalReport.DataSources.Clear();
ReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ReportDataSet", oReports.getVoteResult(dtDateFrom.Value, dtDateTo.Value, txtElectionCode.Text)));
ReportViewer.SetDisplayMode(DisplayMode.PrintLayout);
ReportViewer.ZoomMode = ZoomMode.Percent;
ReportViewer.ZoomPercent = 100;
ReportViewer.RefreshReport();
}
private void btnGenerate_Click(object sender, EventArgs e)
{
string sReportName = string.Empty;
try
{
ReportParameter[] oParameters = new ReportParameter[1];
oParameters[0] = new ReportParameter("Description", cboStatus.Text);
switch (e_ReportStatus)
{
case ePublicVariable.eVariable.BORROWER_STATUS.BORROWER_RECORDLIST:
sReportName = "rptBorrowerList.rdlc";
break;
case ePublicVariable.eVariable.BORROWER_STATUS.UNRETURNED_BOOKS:
sReportName = "rptBorrowerTransaction.rdlc";
break;
case ePublicVariable.eVariable.BORROWER_STATUS.REQUESTED_BOOKS:
sReportName = "rptBorrowerTransaction.rdlc";
break;
}
oReports = new DataAccess.Reports();
ReportViewer.LocalReport.ReportPath = sReportPath + sReportName;
ReportViewer.LocalReport.DataSources.Clear();
ReportViewer.LocalReport.SetParameters(oParameters);
ReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ReportDataSet", oReports.Get_BorrowerReport(e_ReportStatus, dtDateFrom.Value, dtDateTo.Value)));
if (e_ReportStatus != ePublicVariable.eVariable.BORROWER_STATUS.BORROWER_RECORDLIST)
{
ReportViewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
}
ReportViewer.SetDisplayMode(DisplayMode.PrintLayout);
ReportViewer.ZoomMode = ZoomMode.Percent;
ReportViewer.ZoomPercent = 100;
ReportViewer.RefreshReport();
}
catch (Exception ex)
{ }
}
private void btnGenerate_Click(object sender, EventArgs e)
{
try
{
ReportParameter[] oParameters = new ReportParameter[1];
oParameters[0] = new ReportParameter("Description", cboStatus.Text);
string sReportName = "rptBookList.rdlc";
oReports = new DataAccess.Reports();
ReportViewer.LocalReport.ReportPath = sReportPath + sReportName;
ReportViewer.LocalReport.DataSources.Clear();
ReportViewer.LocalReport.SetParameters(oParameters);
ReportViewer.LocalReport.DataSources.Add(new ReportDataSource("ReportDataSet", oReports.Get_BookReport(e_ReportStatus, dtDateFrom.Value, dtDateTo.Value)));
ReportViewer.SetDisplayMode(DisplayMode.PrintLayout);
ReportViewer.ZoomMode = ZoomMode.Percent;
ReportViewer.ZoomPercent = 100;
ReportViewer.RefreshReport();
}
catch (Exception ex)
{ }
}
void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e)
{
ePublicVariable.eVariable.sBorrowerID = e.Parameters["BORROWER_ID"].Values.ToList().SingleOrDefault();
oReports = new DataAccess.Reports();
e.DataSources.Add(new ReportDataSource("ReportDataSet", oReports.Get_BorrowerSubReport(e_ReportStatus, ePublicVariable.eVariable.sBorrowerID, dtDateFrom.Value, dtDateTo.Value)));
}
