public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
WorkDistributionMainCodeWiseRPT rpt = new WorkDistributionMainCodeWiseRPT();
rpt.Site = this.Site;
return(rpt);
}
private void btnDisplay_Click(object sender, EventArgs e)
{
try
{
DateTime dtFromDate = new DateTime(dtpFrom.Value.Year, dtpFrom.Value.Month, 1);
DateTime dtMonthEndDate = dtFromDate.AddMonths(1).AddDays(-1);
DateTime dtYearStartDate = new DateTime(dtpFrom.Value.Date.Year, 1, 1);
DateTime dtToDate = dtpFrom.Value.Date;
DataSet dataSetReport = new DataSet();
String strAllDivisions = "%";
if (chkAll.Checked)
{
strAllDivisions = "%";
}
else
{
strAllDivisions = cmbDivision.SelectedValue.ToString();
}
dataSetReport = myReports.getWorkDistributionMainCodeWise(dtpFrom.Value.Date, strAllDivisions);
dataSetReport.WriteXml("WorkDistributionMainCodeWise.xml");
if (dataSetReport.Tables[0].Rows.Count > 0)
{
WorkDistributionMainCodeWiseRPT myaclist = new WorkDistributionMainCodeWiseRPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("CompanyName", FTSPayRollBL.Company.getCompanyName());
myaclist.SetParameterValue("Estate", mydiv.ListEstates().Rows[0][0].ToString());
myaclist.SetParameterValue("Options", "To Date : " + dtpFrom.Value.Date);
myaclist.SetParameterValue("date", " From " + dtFromDate + " To " + dtMonthEndDate);
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
else
{
MessageBox.Show("No Data to preview..!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
