public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { TotalMonthlyReport rpt = new TotalMonthlyReport(); rpt.Site = this.Site; return(rpt); }
private void generateReport() { TotalMonthlyData reportDetails = new TotalMonthlyData(); TotalMonthlyReport report = new TotalMonthlyReport(); DataTable dataTable = reportDetails.TotalMonthlyTable; readCompanyDetails(); storeSales(); storeExpense(); DataRow drow = dataTable.NewRow(); drow["CompanyName"] = companyName; drow["CompanyDetails"] = companyDetails; string[] sDate = Regex.Split(startDate.ToString(), " "); drow["StartDate"] = sDate[0]; string[] eDate = Regex.Split(endDate.ToString(), " "); drow["EndDate"] = eDate[0]; drow["TotalSales"] = totalSalesList.Sum(); drow["TotalCredit"] = totalCreditList.Sum(); dataTable.Rows.Add(drow); for (int i = 0; i < expenseNameList.Count; i++) { DataRow dr = dataTable.NewRow(); string[] exDate = Regex.Split(expenseDateList[i], " "); dr["ExpenseName"] = expenseNameList[i] + ", " + exDate[0]; dr["ExpenseAmount"] = expenseAmountList[i]; dataTable.Rows.Add(dr); } cashBalance = totalSalesList.Sum() - totalCreditList.Sum() - expenseAmountList.Sum(); DataRow dro = dataTable.NewRow(); dro["TotalExpense"] = expenseAmountList.Sum(); dro["CashBalance"] = cashBalance; dataTable.Rows.Add(dro); report.Database.Tables["TotalMonthlyTable"].SetDataSource((DataTable)dataTable); totalMonthlyReportViewer.ViewerCore.ReportSource = report; report.Refresh(); }