public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
YearReport rpt = new YearReport();
rpt.Site = this.Site;
return(rpt);
}
public void btReportYear_Click(object sender, EventArgs e)
{
string sql = @"SELECT Month(dbo.tb_Selling.dateCome) AS month, SUM(dbo.tb_SellDetail.foodPrice * dbo.tb_SellDetail.foodAmount) AS Total
FROM dbo.tb_SellDetail INNER JOIN
dbo.tb_Selling ON dbo.tb_SellDetail.SellID = dbo.tb_Selling.SellID
WHERE (YEAR(dbo.tb_Selling.dateCome) = " + System.Convert.ToString(cbYear.SelectedItem) + @")
GROUP BY month(dbo.tb_Selling.dateCome)";
DSReport dsr = new DSReport();
YearReport rpt = new YearReport();
var da = new SqlDataAdapter(sql, ConstVar.connect.DatabaseConnection(ConstVar.constr));
da.Fill(dsr, "DTReportYear");
if (dsr.Tables["DTReportYear"].Rows.Count == 0)
{
MessageBox.Show("ບໍ່ມີຂໍ້ມູນໃນປີທີເລືອກ");
}
else
{
rpt.SetDataSource(dsr);
rpt.SetParameterValue("year", cbYear.Text);
frm_MainReportChoosing.Default.CrystalReportViewer1.ReportSource = rpt;
frm_MainReportChoosing.Default.Show(this);
}
}
