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..!");
}
}
