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