private void ReportTest_Load(object sender, EventArgs e) { //// TODO: This line of code loads data into the 'peopleWithRemainAccount.peoplewithremainaccount' table. You can move, or remove it, as needed. //this.peoplewithremainaccountTableAdapter.Fill(this.peopleWithRemainAccount.peoplewithremainaccount); //string imagePath = new Uri(Application.StartupPath + @"\images\logo.png").AbsoluteUri; //ReportParameter rpLogo = new ReportParameter("rpLogoPath", imagePath); //ReportParameter rpReportDate = new ReportParameter("rpReportDate", GS.dateManager.GetCurrentDate()); //reportViewer1.LocalReport.EnableExternalImages = true; //reportViewer1.LocalReport.SetParameters(rpLogo); //reportViewer1.LocalReport.SetParameters(rpReportDate); //this.reportViewer1.RefreshReport(); #region Set Report Needs and show report ///////////////////////// Start Set value to Parameter of Report ///////////////////////// #region Report Parameters List <ReportParameter> rp = new List <ReportParameter>(); rp.Add(new ReportParameter("rpReportDate", GS.dateManager.GetCurrentPersianDate())); #endregion #region Report datasource List <ReportDataSource> rdsList = new List <ReportDataSource>(); string q = "SELECT * FROM `peoplewithremainaccount`"; rdsList.Add(new ReportDataSource("DSPeopleWithRemainaccount", GS.db.Query(q))); #endregion #region Set frmReport Properties and show this form frmReports frmR = new frmReports(); frmR.RPList = rp; frmR.reportType = ReportType.PeopleRemainAccount; frmR.rdsList = rdsList; string ReportPath = Path.Combine(Application.StartupPath, @"reports\PeopleWithRemainAccount.rdlc"); frmR.ReportPath = ReportPath; frmR.ShowDialog(this); #endregion ///////////////////////// End Set value to Parameter of Report ///////////////////////// #endregion this.Close(); }
private void btnRepSelNum_Click(object sender, EventArgs e) { #region Set Report Needs and show report ///////////////////////// Start Set value to Parameter of Report ///////////////////////// #region Report datasource List <ReportDataSource> rdsList = new List <ReportDataSource>(); string d = GS.dateManager.GetCurrentPersianDate(); d = d.Substring(0, 7); string q = string.Format("SELECT * FROM {0}`invoicedetails` WHERE `type` = '{1}' ORDER BY `id` ASC", DBName, Invoice.InvoiceType.sell); DataTable dtDSMonthlyReport = GS.db.Query(q); if (dtDSMonthlyReport.Rows.Count == 0) { MessageBox.Show("در ماه جاری هیچ تراکنشی ثبت نشده است."); return; } rdsList.Add(new ReportDataSource("dsInvoiceDetails", dtDSMonthlyReport)); #endregion #region ReportParameter List <ReportParameter> rpList = new List <ReportParameter>(); //rpList.Add(new ReportParameter("rpReportDate",GS.dateManager.GetCurrentPersianDate() )); #endregion #region Set frmReport Properties and show this form frmReports frmR = new frmReports(); //frmR.RPList = null; frmR.reportType = ReportType.ItemSell; frmR.rdsList = rdsList; foreach (ReportParameter rp in rpList) { frmR.RPList.Add(rp); } string ReportPath = Path.Combine(Application.StartupPath, @"reports\ItemSell.rdlc"); frmR.ReportPath = ReportPath; frmR.ShowDialog(this); #endregion ///////////////////////// End Set value to Parameter of Report ///////////////////////// #endregion }
private void btnRepMmounth_Click(object sender, EventArgs e) { #region Set Report Needs and show report ///////////////////////// Start Set value to Parameter of Report ///////////////////////// #region Report datasource List <ReportDataSource> rdsList = new List <ReportDataSource>(); string d = GS.dateManager.GetCurrentPersianDate(); d = d.Substring(0, 7); string q = string.Format("SELECT * FROM {0}`accounting` WHERE `payDate` LIKE '{1}%' ORDER BY `id` ASC", DBName, d); DataTable dtDSMonthlyReport = GS.db.Query(q); if (dtDSMonthlyReport == null) { MessageBox.Show("در ماه جاری هیچ تراکنشی ثبت نشده است."); return; } if (dtDSMonthlyReport.Rows.Count == 0) { MessageBox.Show("در ماه جاری هیچ تراکنشی ثبت نشده است."); return; } rdsList.Add(new ReportDataSource("dsMonthlyReport", dtDSMonthlyReport)); #endregion #region Set frmReport Properties and show this form frmReports frmR = new frmReports(); //frmR.RPList = null; frmR.reportType = ReportType.MonthlyReport; frmR.rdsList = rdsList; string ReportPath = Path.Combine(Application.StartupPath, @"reports\monthlyReport.rdlc"); frmR.ReportPath = ReportPath; frmR.ShowDialog(this); #endregion ///////////////////////// End Set value to Parameter of Report ///////////////////////// #endregion }