01.private void btReport_Click(object sender, EventArgs e)
02. {
03. Con = new SqlConnection(strCon);
04.
05. Con.Open();
06.
07. String tempSelect = "";
08.
09. if (cboMain.SelectedItem.ToString() == "-วัน-")
10. {
11. sql = "select * from vwReport where day(detail_date)='" + cboSub.SelectedValue.ToString() + "'";
12. tempSelect = "วัน";
13. }
14. else if (cboMain.SelectedItem.ToString() == "-เดือน-")
15. {
16. sql = "select * from vwReport where month(detail_date)='" + cboSub.SelectedValue.ToString() + "'";
17. tempSelect = "เดือน";
18. }
19. else
20. {
21. sql = "select * from vwReport where year(detail_date)='" + cboSub.SelectedValue.ToString() + "'";
22. tempSelect = "ปี";
23. }
24.
25. adap = new SqlDataAdapter(sql, Con);
26. adap.Fill(ds);
27.
28. ProductReport rpt = new ProductReport();
29. rpt.SetDataSource(ds);
30.
31. frmPreview f = new frmPreview();
32.
33. f.crystalReportViewer1.ReportSource = rpt;
34.
35. f.crystalReportViewer1.Refresh();
36.
37. f.Text = "Product Report( Detail_Date ตาม " + tempSelect + ")";
38.
39. f.Show();
40.
41. Con.Close();
42. }
