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)
            {
            }
        }
Beispiel #2
0
        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
            {
            }
        }