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); } }