Beispiel #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            MonthlyBankWiseRPT rpt = new MonthlyBankWiseRPT();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void cmdDisplay_Click(object sender, EventArgs e)
        {
            try
            {
                DataSet ds = new DataSet();

                if (allCheck.Checked)
                {
                    ds = myBank.getBankwiseReport(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
                    ds.WriteXml("allBank.xml");
                    string             Allroute         = "ALL";
                    MonthlyBankWiseRPT oBankwiseRepoort = new MonthlyBankWiseRPT();
                    oBankwiseRepoort.SetDataSource(ds);
                    oBankwiseRepoort.SetParameterValue("Route", Allroute);
                    oBankwiseRepoort.SetParameterValue("Month", cmbMonth.Text);
                    oBankwiseRepoort.SetParameterValue("Year", cmbYear.Text);
                    oBankwiseRepoort.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
                    ReportViewer oReportViewer = new ReportViewer();
                    oReportViewer.crystalReportViewer1.ReportSource = oBankwiseRepoort;
                    oReportViewer.Show();
                }
                else
                {
                    ds = myBank.getBankwiseReportRouteWise(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbRoute.SelectedValue.ToString());
                    ds.WriteXml("allBank.xml");
                    MonthlyBankWiseRPT oBankwiseRepoort = new MonthlyBankWiseRPT();
                    oBankwiseRepoort.SetDataSource(ds);
                    oBankwiseRepoort.SetParameterValue("Route", cmbRoute.Text);
                    oBankwiseRepoort.SetParameterValue("Month", cmbMonth.Text);
                    oBankwiseRepoort.SetParameterValue("Year", cmbYear.Text);
                    oBankwiseRepoort.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
                    ReportViewer oReportViewer = new ReportViewer();
                    oReportViewer.crystalReportViewer1.ReportSource = oBankwiseRepoort;
                    oReportViewer.Show();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }