private void ShowReport(string ID) { try { ReportViewer1.LocalReport.DataSources.Clear(); DSEstateManagement ds = new DSEstateManagement(); string reportPath = Server.MapPath("EstatePlotInstallmentsPaymentRpt.rdlc"); DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter da1 = new DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter(); DSEstateManagementTableAdapters.usp_EstatePlotInstallmentsPaymentRptTableAdapter da2 = new DSEstateManagementTableAdapters.usp_EstatePlotInstallmentsPaymentRptTableAdapter(); da1.Fill(ds.usp_EstatePlotInfoRpt, Convert.ToInt32(ID)); da2.Fill(ds.usp_EstatePlotInstallmentsPaymentRpt, Convert.ToInt32(ID)); ReportViewer1.LocalReport.EnableExternalImages = true; ReportViewer1.LocalReport.ReportPath = reportPath; ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", ds.Tables["usp_EstatePlotInfoRpt"])); ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet2", ds.Tables["usp_EstatePlotInstallmentsPaymentRpt"])); ReportViewer1.LocalReport.Refresh(); } catch (Exception e) { } }
private void IndustriesDetailReportHandler(object sender, SubreportProcessingEventArgs e) { int PlotOwnerShipID = Convert.ToInt32(e.Parameters["PlotOwnerShipID"].Values[0]); DSEstateManagement ds = new DSEstateManagement(); DSEstateManagementTableAdapters.usp_EstatePlotOwnerwiseIndustiesInfoRptTableAdapter da = new DSEstateManagementTableAdapters.usp_EstatePlotOwnerwiseIndustiesInfoRptTableAdapter(); da.Fill(ds.usp_EstatePlotOwnerwiseIndustiesInfoRpt, PlotOwnerShipID); ReportDataSource dsRpt = new ReportDataSource("DataSet1", ds.Tables["usp_EstatePlotOwnerwiseIndustiesInfoRpt"]); e.DataSources.Add(dsRpt); }
private void ShowReport(string ID) { try { ReportViewer1.LocalReport.DataSources.Clear(); DSEstateManagement ds = new DSEstateManagement(); string reportPath = Server.MapPath("PlotPreviousHistoryRpt.rdlc"); DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter da1 = new DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter(); DSEstateManagementTableAdapters.usp_EstatePlotPreviousHistoryIndustryInfoRptTableAdapter da2 = new DSEstateManagementTableAdapters.usp_EstatePlotPreviousHistoryIndustryInfoRptTableAdapter(); da1.Fill(ds.usp_EstatePlotInfoRpt, Convert.ToInt32(ID)); da2.Fill(ds.usp_EstatePlotPreviousHistoryIndustryInfoRpt, Convert.ToInt32(ID)); ReportParameter paramLogo = new ReportParameter(); paramLogo.Name = "PicPath"; paramLogo.Values.Add(ServerPath); ReportViewer1.LocalReport.EnableExternalImages = true; ReportViewer1.LocalReport.ReportPath = reportPath; ReportViewer1.LocalReport.SetParameters(paramLogo); ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", ds.Tables["usp_EstatePlotInfoRpt"])); ReportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource("DataSet2", ds.Tables["usp_EstatePlotPreviousHistoryIndustryInfoRpt"])); ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(OwnerDetailReportHandler); ReportViewer1.LocalReport.Refresh(); } catch (Exception e) { } }
private void ShowReport(string ID) { try { ReportViewer1.LocalReport.DataSources.Clear(); DSEstateManagement ds = new DSEstateManagement(); string reportPath = Server.MapPath("StatusDevelopmentChargesRpt.rdlc"); DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter da1 = new DSEstateManagementTableAdapters.usp_EstatePlotInfoRptTableAdapter(); DSEstateManagementTableAdapters.usp_EstatePlotChargesRptTableAdapter da2 = new DSEstateManagementTableAdapters.usp_EstatePlotChargesRptTableAdapter(); da1.Fill(ds.usp_EstatePlotInfoRpt, Convert.ToInt32(ID)); da2.Fill(ds.usp_EstatePlotChargesRpt, Convert.ToInt32(ID), Convert.ToDateTime(txtFromDate.Text.Trim()), Convert.ToDateTime(txtToDate.Text.Trim())); ReportParameter BetweenDates = new ReportParameter(); BetweenDates.Name = "BetweenDates"; BetweenDates.Values.Add("From : " + txtFromDate.Text.Trim() + " To : " + txtToDate.Text.Trim()); ReportViewer1.LocalReport.EnableExternalImages = true; ReportViewer1.LocalReport.ReportPath = reportPath; ReportViewer1.LocalReport.SetParameters(BetweenDates); ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", ds.Tables["usp_EstatePlotInfoRpt"])); ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", ds.Tables["usp_EstatePlotChargesRpt"])); ReportViewer1.LocalReport.Refresh(); } catch (Exception) { } finally { } }