예제 #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            EmployeeWiseEPFETFSummeryRPT rpt = new EmployeeWiseEPFETFSummeryRPT();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void btnPreview_Click(object sender, EventArgs e)
        {
            if (String.IsNullOrEmpty(cmbStartMonth.Text))
            {
                MessageBox.Show("Select The Start Month");
            }
            else if (String.IsNullOrEmpty(cmbEndMonth.Text))
            {
                MessageBox.Show("Select The End Month");
            }
            else
            {
                String strAllDiv = "";

                if (chkAllDivisions.Checked)
                {
                    strAllDiv = "%";
                }
                else
                {
                    strAllDiv = cmbDivision.SelectedValue.ToString();
                }

                try
                {
                    dataSetReport = myReports.getEmployeeWiseEPFETFSummary(Convert.ToInt32(cmbStartMonth.Text), Convert.ToInt32(cmbEndMonth.Text), strAllDiv);
                    dataSetReport.WriteXml("EmployeeWiseEPFETFSummery.xml");

                    if (dataSetReport.Tables[0].Rows.Count > 0)
                    {
                        EmployeeWiseEPFETFSummeryRPT myEPFETFSummery = new EmployeeWiseEPFETFSummeryRPT();
                        myEPFETFSummery.SetDataSource(dataSetReport);
                        ReportViewer myReportViewer = new ReportViewer();

                        myEPFETFSummery.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
                        myEPFETFSummery.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString());
                        myEPFETFSummery.SetParameterValue("DateRange", "From: " + cmbStartMonth.Text + " To :" + cmbEndMonth.Text);
                        myReportViewer.crystalReportViewer1.ReportSource = myEPFETFSummery;
                        myReportViewer.Show();
                    }
                    else
                    {
                        MessageBox.Show("No data to preview..!");
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error On Get Data, " + ex.Message);
                }
            }
        }