public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { DailyWorkDistributionWithoutHalfNames rpt = new DailyWorkDistributionWithoutHalfNames(); rpt.Site = this.Site; return(rpt); }
private void button1_Click(object sender, EventArgs e) { DataSet dataSetReport = new DataSet(); DataSet dataSetReportSub = new DataSet(); String strDivisionID = "%"; String strDivisionName = "ALL"; DateTime dtFrom; DateTime dtTo; if (chkAllDivisions.Checked) { strDivisionID = "%"; } else { strDivisionID = cmbDivision.SelectedValue.ToString(); strDivisionName = cmbDivision.Text; } Int32 intworktyp = 1; if (rbNormal.Checked) { intworktyp = 1; } else { intworktyp = 2; } if (chkDateRange.Checked) { dtFrom = dtpFrom.Value.Date; dtTo = dtpTo.Value.Date; } else { dtFrom = new DateTime(Convert.ToInt32(cmbYear.SelectedValue.ToString()), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), 1); dtTo = new DateTime(Convert.ToInt32(cmbYear.SelectedValue.ToString()), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), 1).AddMonths(1).AddDays(-1); } dataSetReport = myReports.DailyWorkDistributionByRange(dtFrom, dtTo, strDivisionID, intworktyp, false); dataSetReport.WriteXml("DailyWorkDistribution.xml"); dataSetReportSub = myReports.DailyWorkDistributionNONWorkByRange(dtFrom, dtTo, strDivisionID, intworktyp); dataSetReportSub.WriteXml("DailyWorkDistributionSub.xml"); if (dataSetReport.Tables[0].Rows.Count > 0) { //DailyWorkDistributionHalfNames myDailyWorkDistributionRPT = new DailyWorkDistributionHalfNames(); DailyWorkDistributionWithoutHalfNames myDailyWorkDistributionRPT = new DailyWorkDistributionWithoutHalfNames(); myDailyWorkDistributionRPT.SetDataSource(dataSetReport); ReportViewer myReportViewer = new ReportViewer(); myDailyWorkDistributionRPT.SetParameterValue("Estate", myDivision.ListEstate().Rows[0][1].ToString()); myDailyWorkDistributionRPT.SetParameterValue("DivisionName", strDivisionName); if (chkDateRange.Checked) { myDailyWorkDistributionRPT.SetParameterValue("Period", "From : " + dtpFrom.Value.Date.ToShortDateString() + " To : " + dtpTo.Value.Date.ToShortDateString()); } else { myDailyWorkDistributionRPT.SetParameterValue("Period", "Month : " + cmbMonth.Text + " / " + cmbYear.Text); } if (intworktyp == 1) { myDailyWorkDistributionRPT.SetParameterValue("WorkType", "For Normal Work"); } else { myDailyWorkDistributionRPT.SetParameterValue("WorkType", "For Cash Work"); } myDailyWorkDistributionRPT.SetParameterValue("HalfNames", "(With Out Holiday Half Names)"); myReportViewer.crystalReportViewer1.ReportSource = myDailyWorkDistributionRPT; myReportViewer.Show(); } else { MessageBox.Show("No Data to Preview..!"); } }