public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { DailyReport rpt = new DailyReport(); rpt.Site = this.Site; return(rpt); }
private void generateReport() { var date = DateTime.Now; endDate = date.ToString("dd-MMM-yy hh:mm:ss tt"); //endDate = "28-May-18 23:59:59 PM"; var dat = DateTime.Today; startDate = dat.ToString("dd-MMM-yy hh:mm:ss tt"); DailyReportData reportDetails = new DailyReportData(); DailyReport report = new DailyReport(); DataTable dtTable = reportDetails.CompanyDetails; readCompanyDetails(); DataRow drr = dtTable.NewRow(); drr["CompanyName"] = companyName; drr["CompanyDetails"] = companyDetails; dtTable.Rows.Add(drr); report.Database.Tables["CompanyDetails"].SetDataSource((DataTable)dtTable); storeSales(); storeExpense(); DataTable dataTable = reportDetails._DailyReportData; DataRow drow = dataTable.NewRow(); drow["StDate"] = endDate; drow["TotalSales"] = totalSalesList.Sum(); drow["TotalCredit"] = totalCreditList.Sum(); dataTable.Rows.Add(drow); for (int i = 0; i < expenseNameList.Count; i++) { DataRow drrow = dataTable.NewRow(); drrow["ExpenseName"] = expenseNameList[i]; drrow["ExpenseAmount"] = expenseAmountList[i]; dataTable.Rows.Add(drrow); } cashBalance = totalSalesList.Sum() - totalCreditList.Sum() - expenseAmountList.Sum(); DataRow dr = dataTable.NewRow(); dr["TotalExpense"] = expenseAmountList.Sum(); dr["CashBalance"] = cashBalance; dataTable.Rows.Add(dr); report.Database.Tables["DailyReportData"].SetDataSource((DataTable)dataTable); dailyReportViewer.ViewerCore.ReportSource = report; report.Refresh(); }