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))); }