public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
EmployeeMovementReport rpt = new EmployeeMovementReport();
rpt.Site = this.Site;
return(rpt);
}
private void cmdDisplay1_Click(object sender, EventArgs e)
{
if (chkAll.Checked == true)
{
DataSet dataSetReport = new DataSet();
DateTime dtStartDate, dtEndDate;
dtStartDate = MyMovRep.GetStartDate(int.Parse(cmbYear.Text.ToString()), int.Parse(cmbMonth.SelectedValue.ToString()));
dtEndDate = MyMovRep.GetEndDateOfMonth(dtStartDate);
dataSetReport = MyMovRep.GetEmployeeMovements1(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("EmployeeMovementsRep.xml");
EmployeeMovementReport myMovementRep = new EmployeeMovementReport();
myMovementRep.SetDataSource(dataSetReport);
myMovementRep.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myMovementRep.SetParameterValue("Estate", "Estate :" + mydiv.ListEstates().Rows[0][0].ToString());
myMovementRep.SetParameterValue("Period", "For the Month of " + cmbMonth.SelectedValue.ToString() + " / " + cmbYear.Text);
ReportViewer myReportViewer = new ReportViewer();
myReportViewer.crystalReportViewer1.ReportSource = myMovementRep;
myReportViewer.Show();
}
else
{
MessageBox.Show(" No Data to Preview ");
}
}
else
{
DataSet dataSetReport = new DataSet();
DateTime dtStartDate, dtEndDate;
dtStartDate = MyMovRep.GetStartDate(int.Parse(cmbYear.Text.ToString()), int.Parse(cmbMonth.SelectedValue.ToString()));
dtEndDate = MyMovRep.GetEndDateOfMonth(dtStartDate);
dataSetReport = MyMovRep.GetEmployeeMovements(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), cmbDivision.SelectedValue.ToString());
if (dataSetReport.Tables[0].Rows.Count > 0)
{
dataSetReport.WriteXml("EmployeeMovementsRep.xml");
EmployeeMovementReport myMovementRep = new EmployeeMovementReport();
myMovementRep.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myMovementRep.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
myMovementRep.SetParameterValue("Estate", "Estate :" + mydiv.ListEstates().Rows[0][0].ToString());
myMovementRep.SetParameterValue("Period", "For the Month of " + cmbMonth.SelectedValue.ToString() + " / " + cmbYear.Text);
myReportViewer.crystalReportViewer1.ReportSource = myMovementRep;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to Preview");
}
}
//dataSetReport = myReports.getEmployeeMovements(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()));
//dataSetReport.WriteXml("EmployeeMovements.xml");
//EmployeeMovementRPT myaclist = new EmployeeMovementRPT();
//myaclist.SetDataSource(dataSetReport);
//ReportViewer myReportViewer = new ReportViewer();
//myaclist.SetParameterValue("Estate", FTSPayRollBL.Company.getCompanyName());
//myaclist.SetParameterValue("Period", "Month of : " + cmbMonth.Text + "/" + cmbYear.Text);
//myReportViewer.crystalReportViewer1.ReportSource = myaclist;
//myReportViewer.Show();
}