public void CreateReport() { SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-GI4R9EJ;Initial Catalog=QUANLYCF1;Integrated Security=True"); con.Open(); SqlCommand cmd = new SqlCommand("select * from HOADONBANHANG where MONTH(THOIGIAN) = Month(GETDATE()) and day(THOIGIAN) = day(GETDATE()) and year(THOIGIAN) = year(GETDATE())", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); Report1 report = new Report1(); report.DataSouce = dt; report.ShowPreview(); }
private void barButtonItem13_ItemClick(object sender, ItemClickEventArgs e) { if (tabPane1.SelectedPageIndex == 3) { if (clientBindingSource1.Current is Client buffer) { buffer.Accountings = Gateway.Call(new GetAccountingByOwnerId() { Id = buffer.Id }).Result; var report = new Report1(); report.objectDataSource1.DataSource = buffer; report.ShowPreview(); } } else { XtraMessageBox.Show("Выберете клиента для вывода в отчёт."); } }