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();
}
