private void btnSearch_Click(object sender, EventArgs e) { ExpenseReport objrep = new ExpenseReport(); rptViewer objView = new rptViewer(); objrep.SetParameterValue("@mindate", txtMinDate.Value); objrep.SetParameterValue("@maxdate", txtmaxdate.Value); ExpenseBL objBL = new ExpenseBL() { mindate = Convert.ToDateTime(txtMinDate.Text), maxdate = Convert.ToDateTime(txtmaxdate.Text) }; var dt = objBL.SelectByDateDiff(); if (dt != null) { objrep.SetDataSource(dt); objView.crptViewer.ReportSource = objrep; objView.WindowState = FormWindowState.Maximized; objView.ShowDialog(); } else { MessageBox.Show("No Record Found"); } //crptViewerExpense.ReportSource = objrep; }
private ExpenseReport GetReport(ExpenseModel data) { var report = new ExpenseReport(); var dataTable = GetDataTable(); var dataSet = new System.Data.DataSet(); dataSet.Tables.Add(dataTable); for (int i = 0; i < data.ExpenseItems.Count; i++) { DataRow row = dataSet.Tables["ExpenseItem"].NewRow(); row["No"] = i + 1; row["Name"] = data.ExpenseItems[i].Name; row["Income"] = data.ExpenseItems[i].Type == 0 ? data.ExpenseItems[i].Money : 0; row["Expense"] = data.ExpenseItems[i].Type == 1 ? data.ExpenseItems[i].Money : 0; dataSet.Tables["ExpenseItem"].Rows.Add(row); } report.SetDataSource(dataSet); report.SetParameterValue("FullName", data.FullName); report.SetParameterValue("Date", data.Date); return(report); }