private void Window_Loaded(object sender, RoutedEventArgs e) { ReportViewerDemo.Reset(); DataTable dt = GetData(); ReportDataSource dsDataSource = new ReportDataSource("DataSet1", dt); //ReportDataSource("", dt); ReportViewerDemo.LocalReport.DataSources.Add(dsDataSource); //embbedded to RDLC report file ReportViewerDemo.LocalReport.ReportEmbeddedResource = "QLTH.BangDiem.rdlc"; //ReportViewerDemo.LocalReport.ReportPath = "\\RDLC_Report\\GiaoVien.rdlc"; //Get information about School such as school's name and principal's name try { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "SELECT HOTEN, MALOP, DTB_HOCKY, XEPLOAI FROM HOCSINH, TONGKET WHERE HOCSINH.MAHS = TONGKET.MAHS AND HOCSINH.NAMHOC = @NAMHOC AND HOCKY = @HOCKY AND TONGKET.MAHS = @MAHS"; cmd.Parameters.AddWithValue("@NAMHOC", strNamHoc); cmd.Parameters.AddWithValue("@HOCKY", drvData.Row[3].ToString()); cmd.Parameters.AddWithValue("@MAHS", drvData.Row[0].ToString()); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { strHoTen = dr.GetString(0); strLop = dr.GetString(1); strDTB = dr.GetDouble(2).ToString(); strXepLoai = dr.GetString(3); } } catch (SqlException) { MessageBox.Show("Có lỗi trong quá trình liên kết cơ sở dữ liệu"); } conn.Close(); //Parameters ReportParameter[] rptParameter = new ReportParameter[] { new ReportParameter("HoTenHS", strHoTen), new ReportParameter("Lop", strLop), new ReportParameter("NamHoc", strNamHoc), new ReportParameter("HocKy", drvData.Row[3].ToString()), new ReportParameter("DTB", strDTB), new ReportParameter("XepLoai", strXepLoai) }; ReportViewerDemo.LocalReport.SetParameters(rptParameter); ReportViewerDemo.RefreshReport(); }
private void Button_Click(object sender, RoutedEventArgs e) { ReportViewerDemo.Reset(); DataTable dt = GetData(); ReportDataSource ds = new ReportDataSource("DataSet1", dt); ReportViewerDemo.LocalReport.DataSources.Add(ds); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "WpfReportDemo.Report1.rdlc"; ReportViewerDemo.RefreshReport(); }
public PayrollPrintView(int payrollPK) { InitializeComponent(); var getPayroll = db.Payrolls.FirstOrDefault(a => a.PayrollPK == 1); //var deductions = db.Deductionss.Where(a => a.PayrollPK == getPayroll.PayrollPK).ToList(); var deductionsJoin = db.Deductionss.Join(db.Payrolls, id => id.PayrollPK, forId => forId.PayrollPK, (id, forId) => new { id = id, forId = forId }) .Where(a => a.id.PayrollPK == payrollPK && a.forId.PayrollPK == payrollPK) .GroupBy(a => a.id.UserName) .Select(l => new { PayrollViewKey = l.Key, UserName = l.FirstOrDefault().id.UserName, LateDeduction = l.FirstOrDefault().id.LateDeduction, BasicSalary = l.FirstOrDefault().id.BasicSalary, Pagibig = l.FirstOrDefault().id.PagibigDeduction, Accumulated = l.FirstOrDefault().id.AllAccumulatedTimeAddition, SSS = l.FirstOrDefault().id.SSSDeduction, TIN = l.FirstOrDefault().id.TinDeduction, TotalSalary = l.FirstOrDefault().id.TotalSalary, PayrollStart = l.FirstOrDefault().forId.StartPayroll, PayrollEnd = l.FirstOrDefault().forId.EndPayroll }).ToList(); var otherJoin = deductionsJoin.Join(db.Employees, id => id.UserName, forId => forId.UserName, (id, forId) => new { id = id, forId = forId }).Where(a => a.id.UserName == a.forId.UserName).GroupBy(a => a.id.UserName) .Select(l => new { PayrollViewKey = l.Key, UserName = l.FirstOrDefault().id.UserName, LateDeduction = l.FirstOrDefault().id.LateDeduction, BasicSalary = l.FirstOrDefault().id.BasicSalary, Pagibig = l.FirstOrDefault().id.Pagibig, Accumulated = l.FirstOrDefault().id.Accumulated, SSS = l.FirstOrDefault().id.SSS, TIN = l.FirstOrDefault().id.TIN, TotalSalary = l.FirstOrDefault().id.TotalSalary, PayrollStart = l.FirstOrDefault().id.PayrollStart, PayrollEnd = l.FirstOrDefault().id.PayrollEnd, FirstName = l.FirstOrDefault().forId.FirstName, LastName = l.FirstOrDefault().forId.LastName }).ToList(); ReportViewerDemo.Reset(); DataTable dt = ToDataTable(otherJoin); ReportDataSource ds = new ReportDataSource("dataset", dt); ReportViewerDemo.LocalReport.DataSources.Add(ds); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "EyeKnowRight.Reports.PayrollReport.rdlc"; ReportViewerDemo.RefreshReport(); }
public Report(int id) { InitializeComponent(); this.id = id; ReportViewerDemo.Reset(); DataTable dt = GetData(); Microsoft.Reporting.WinForms.ReportDataSource ds = new Microsoft.Reporting.WinForms.ReportDataSource("DataSet1", dt); ReportViewerDemo.LocalReport.DataSources.Add(ds); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "DoctorCashWpf.Printer.Report1.rdlc"; ReportViewerDemo.RefreshReport(); }
public ReportsView() { InitializeComponent(); ReportViewerDemo.Reset(); ReportDataSource reportDataSource = new ReportDataSource("DataSet1", RegistroNacional.Instance.ListaCiudades); ReportViewerDemo.LocalReport.DataSources.Add(reportDataSource); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "MVVM_Template_Prism_WPF.Report1.rdlc"; ReportViewerDemo.RefreshReport(); }
private void Window_Loaded(object sender, RoutedEventArgs e) { ReportViewerDemo.Reset(); DataTable dt = GetData(); ReportDataSource dsDataSource = new ReportDataSource("DataSet1", dt); //ReportDataSource("", dt); ReportViewerDemo.LocalReport.DataSources.Add(dsDataSource); //embbedded to RDLC report file ReportViewerDemo.LocalReport.ReportEmbeddedResource = "QLTH.HocSinh.rdlc"; //ReportViewerDemo.LocalReport.ReportPath = "\\RDLC_Report\\GiaoVien.rdlc"; //Get information about School such as school's name and principal's name try { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "Select * from THONGTINTRG"; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { strName = dr.GetString(1); strHieuTruong = dr.GetString(3); } } catch (SqlException) { MessageBox.Show("Có lỗi trong quá trình liên kết cơ sở dữ liệu"); } conn.Close(); //Parameters ReportParameter[] rptParameter = new ReportParameter[] { new ReportParameter("TenTruong", strName.ToUpper()), new ReportParameter("TenHT", strHieuTruong), new ReportParameter("NamHoc", strNamHoc), new ReportParameter("Khoi", iKhoi.ToString()) }; ReportViewerDemo.LocalReport.SetParameters(rptParameter); ReportViewerDemo.RefreshReport(); }
public MainEmployeeMasterlistView(dynamic reportObject, dynamic date) { InitializeComponent(); ReportViewerDemo.Reset(); DataTable dt = ToDataTable(reportObject); ReportDataSource ds = new ReportDataSource("employeemasterlist", dt); ReportViewerDemo.LocalReport.DataSources.Add(ds); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "EyeKnowRight.Reports.EmployeeMasterlist.rdlc"; ReportViewerDemo.RefreshReport(); }
public MainTopPerformingView(dynamic reportObject, dynamic date) { InitializeComponent(); ReportViewerDemo.Reset(); DataTable dt = ToDataTable(reportObject); DataTable dates = ToDataTable(date); ReportDataSource ds = new ReportDataSource("topperforming", dt); ReportDataSource date1 = new ReportDataSource("dateTime", dates); ReportViewerDemo.LocalReport.DataSources.Add(ds); ReportViewerDemo.LocalReport.DataSources.Add(date1); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "EyeKnowRight.Reports.TopPerformingReport.rdlc"; ReportViewerDemo.RefreshReport(); }
public MainAssesmentReportsView(dynamic reportObject, dynamic date) { InitializeComponent(); ReportViewerDemo.Reset(); DataTable dt = ToDataTable(reportObject); DataTable dates = ToDataTable(date); ReportDataSource ds = new ReportDataSource("assesmentreport", dt); ReportDataSource date2 = new ReportDataSource("dateTime", dates); ReportViewerDemo.LocalReport.DataSources.Add(ds); ReportViewerDemo.LocalReport.DataSources.Add(date2); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "EyeKnowRight.Reports.AssesmentReport.rdlc"; ReportViewerDemo.RefreshReport(); }
public MainReportsView(dynamic reportObject, dynamic reportDate) { InitializeComponent(); ReportViewerDemo.Reset(); DataTable dt = ToDataTable(reportObject); DataTable reportD = ToDataTable(reportDate); ReportDataSource ds = new ReportDataSource("mainattendancereport", dt); ReportDataSource date = new ReportDataSource("dateTime", reportD); ReportViewerDemo.LocalReport.DataSources.Add(ds); ReportViewerDemo.LocalReport.DataSources.Add(date); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "EyeKnowRight.Reports.AttendanceReport.rdlc"; ReportViewerDemo.RefreshReport(); }
private void Load() { ReportViewerDemo.Reset(); DataTable dt = GetData(); ReportDataSource dsDataSource = new ReportDataSource("DataSet1", dt); //ReportDataSource("", dt); ReportViewerDemo.LocalReport.DataSources.Add(dsDataSource); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "QuanLyHocSinh_OOAD.TongKet.rdlc"; try { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = "Select * from THONGTINTRG"; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { strName = dr.GetString(1); strHieuTruong = dr.GetString(3); } } catch (SqlException) { MessageBox.Show("Có lỗi trong quá trình liên kết cơ sở dữ liệu"); } conn.Close(); //Parameters ReportParameter[] rptParameter = new ReportParameter[] { new ReportParameter("TenTruong", strName.ToUpper()), new ReportParameter("TenHT", strHieuTruong), new ReportParameter("Lop", lop), new ReportParameter("NienKhoa", nienKhoa), new ReportParameter("HocKi", hocki.ToString()) }; ReportViewerDemo.LocalReport.SetParameters(rptParameter); ReportViewerDemo.RefreshReport(); }
public EvaluationPrintView(int evaluationPk) { InitializeComponent(); var getEval = db.Evaluations.Where(a => a.EvaluationPK == evaluationPk).ToList(); //var deductions = db.Deductionss.Where(a => a.PayrollPK == getPayroll.PayrollPK).ToList(); ReportViewerDemo.Reset(); DataTable dt = ToDataTable(getEval); ReportDataSource ds = new ReportDataSource("evaluation", dt); ReportViewerDemo.LocalReport.DataSources.Add(ds); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "EyeKnowRight.Reports.EvaluationPrint.rdlc"; ReportViewerDemo.RefreshReport(); }
public DailyAttendanceReport(List <DailyTimeRecord> dailyRecord) { InitializeComponent(); try { ReportViewerDemo.Reset(); DataTable dt = ToDataTable(dailyRecord); ReportDataSource ds = new ReportDataSource("attendance", dt); var user = dailyRecord.FirstOrDefault().UserName; var getUser = db.Employees.Where(a => a.UserName == user).ToList(); ReportDataSource fullNameDataSource = new ReportDataSource("fullName", getUser); ReportViewerDemo.LocalReport.DataSources.Add(ds); ReportViewerDemo.LocalReport.DataSources.Add(fullNameDataSource); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "EyeKnowRight.Reports.DailyReportPrint.rdlc"; ReportViewerDemo.RefreshReport(); }catch (Exception e) { } }
public void loadReport() { ReportDataSource rptDataSource; try { this.ReportViewerDemo.LocalReport.DataSources.Clear(); ReportViewerDemo.LocalReport.ReportEmbeddedResource = "NavigationDrawerPopUpMenu2.Report1.rdlc"; DataSet1 ds = new DataSet1(); conn.Open(); string query = "SELECT * FROM datasalesinventory WHERE salesTransNo='" + win_pos.orderNo.Text + "' AND salesStatus = 'Pending'"; MySqlDataAdapter da = conn.DataAdapter(query); da.Fill(ds.Tables["dtSold"]); conn.Close(); // Parameters ReportParameter pStoreName = new ReportParameter("pStoreName", store.storeName(conn)); ReportParameter pStoreAddress = new ReportParameter("pStoreAddress", store.storeAddress(conn)); ReportParameter pTin = new ReportParameter("pTin", "Tin: " + store.storeTin(conn)); ReportParameter pSerialNumber = new ReportParameter("pSerialNumber", "Serial No.: " + store.storeSN(conn)); ReportParameter pMin = new ReportParameter("pMin", "Min: " + store.storeMin(conn)); ReportParameter pCashierName = new ReportParameter("pCashierName", "Cashier: " + win_pos.cashierName.Text); ReportParameter pTransNo = new ReportParameter("pTransNo", "Trans #: " + win_pos.orderNo.Text); ReportParameter pSubTotal = new ReportParameter("pSubTotal", win_pos.pay_subtotal.Text); ReportParameter pTotal = new ReportParameter("pTotal", win_pos.pay_total.Text); ReportParameter pCash = new ReportParameter("pCash", win_pos.pay_paid.Text); ReportParameter pChange = new ReportParameter("pChange", win_pos.pay_due.Text); ReportParameter pTax = new ReportParameter("pTax", win_pos.pay_tax.Text); ReportParameter pDiscount = new ReportParameter("pDiscount", win_pos.discount); ReportParameter pVatable = new ReportParameter("pVatable", win_pos.sumOfSalesTotals()); // Set Parameters ReportViewerDemo.LocalReport.SetParameters(pStoreName); ReportViewerDemo.LocalReport.SetParameters(pStoreAddress); ReportViewerDemo.LocalReport.SetParameters(pTin); ReportViewerDemo.LocalReport.SetParameters(pSerialNumber); ReportViewerDemo.LocalReport.SetParameters(pMin); ReportViewerDemo.LocalReport.SetParameters(pCashierName); ReportViewerDemo.LocalReport.SetParameters(pTransNo); ReportViewerDemo.LocalReport.SetParameters(pSubTotal); ReportViewerDemo.LocalReport.SetParameters(pTotal); ReportViewerDemo.LocalReport.SetParameters(pCash); ReportViewerDemo.LocalReport.SetParameters(pChange); ReportViewerDemo.LocalReport.SetParameters(pTax); ReportViewerDemo.LocalReport.SetParameters(pDiscount); ReportViewerDemo.LocalReport.SetParameters(pVatable); rptDataSource = new ReportDataSource("DataSet1", ds.Tables["dtSold"]); this.ReportViewerDemo.LocalReport.DataSources.Add(rptDataSource); ReportViewerDemo.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); ReportViewerDemo.ZoomMode = ZoomMode.Percent; ReportViewerDemo.ZoomPercent = 100; } catch (Exception ex) { conn.Close(); MessageBox.Show(ex.Message + ", Try again later", "Receipt Printing Failed", MessageBoxButton.OK, MessageBoxImage.Warning); } }