public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
GreenLeafSummaryROUTERPT rpt = new GreenLeafSummaryROUTERPT();
rpt.Site = this.Site;
return(rpt);
}
private void cmdShow_Click(object sender, EventArgs e)
{
try
{
DataSet dataSetReport = new DataSet();
BoughtLeafBusinessLayer.Reports myReports = new BoughtLeafBusinessLayer.Reports();
String strAllRoute = "%";
if (!chkRoute.Checked)
{
strAllRoute = cmbRoute.SelectedValue.ToString();
}
String strAllLeafType = "%";
if (!chkAllType.Checked)
{
strAllLeafType = cmbLeafType.Text;
}
dataSetReport = myReports.getGreenLeafSummary(Convert.ToInt32(cmbYear.Text), Convert.ToInt32(cmbMonth.SelectedValue.ToString()), strAllRoute, strAllLeafType);
dataSetReport.WriteXml("GreenLeafSummary.xml");
GreenLeafSummaryROUTERPT myaclist = new GreenLeafSummaryROUTERPT();
myaclist.SetDataSource(dataSetReport);
ReportViewer myReportViewer = new ReportViewer();
myaclist.SetParameterValue("Company", BoughtLeafBusinessLayer.BLUser.getCompanyName());
myaclist.SetParameterValue("Year", cmbYear.Text);
myaclist.SetParameterValue("Month", cmbMonth.Text);
if (chkRoute.Checked == true)
{
myaclist.SetParameterValue("Route", "All Routes");
}
else
{
myaclist.SetParameterValue("Route", cmbRoute.Text);
}
myReportViewer.crystalReportViewer1.ReportSource = myaclist;
myReportViewer.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
