public void btReportDate_Click(object sender, EventArgs e) { string sql = @" SELECT top " + System.Convert.ToString(int.Parse(txtTop.Text)) + @" dbo.tb_SellDetail.foodID, dbo.tb_FoodAndDrink.foodName, COUNT(dbo.tb_SellDetail.foodID) AS SellAmount, dbo.tb_Unit.UnitName FROM dbo.tb_Selling INNER JOIN dbo.tb_SellDetail ON dbo.tb_Selling.SellID = dbo.tb_SellDetail.SellID INNER JOIN dbo.tb_FoodAndDrink ON dbo.tb_SellDetail.foodID = dbo.tb_FoodAndDrink.foodID INNER JOIN dbo.tb_Unit ON dbo.tb_FoodAndDrink.UnitID = dbo.tb_Unit.UnitID Where (dbo.tb_selldetail.sellID in (select SellID from dbo.tb_selling as Sell where (month(dateCome)='" + System.Convert.ToString(cbMonth.SelectedItem) + "') and (year(dateCome)='" + System.Convert.ToString(cbYear.SelectedItem) + @"'))) GROUP BY dbo.tb_SellDetail.foodID, dbo.tb_FoodAndDrink.foodName, dbo.tb_Unit.UnitName, dbo.tb_Unit.UnitName order by sellAmount desc"; DSReport dsr = new DSReport(); BestSellByMonthAndYear rpt = new BestSellByMonthAndYear(); var da = new SqlDataAdapter(sql, ConstVar.connect.DatabaseConnection(ConstVar.constr)); da.Fill(dsr, "DTMonthSellGood"); if (dsr.Tables["DTMonthSellGood"].Rows.Count == 0) { MessageBox.Show("ບໍ່ມີຂໍ້ມູນ"); } else { rpt.SetDataSource(dsr); rpt.SetParameterValue("top", txtTop.Text); rpt.SetParameterValue("month", cbMonth.SelectedItem); rpt.SetParameterValue("year", cbYear.SelectedItem); frm_MainReportChoosing.Default.CrystalReportViewer1.ReportSource = rpt; frm_MainReportChoosing.Default.Show(this); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { BestSellByMonthAndYear rpt = new BestSellByMonthAndYear(); rpt.Site = this.Site; return(rpt); }