public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
MonthlyReport rpt = new MonthlyReport();
rpt.Site = this.Site;
return(rpt);
}
private void monthlyReport()
{
MonthlyReportData reportDetails = new MonthlyReportData();
DataTable dtTable = reportDetails.CompanyDetails;
MonthlyReport Report = new MonthlyReport();
readCompanyDetails();
DataRow drr = dtTable.NewRow();
drr["CompanyName"] = companyName;
drr["CompanyDetails"] = companyDetails;
dtTable.Rows.Add(drr);
Report.Database.Tables["CompanyDetails"].SetDataSource((DataTable)dtTable);
monthlyList();
DataTable dataTable = reportDetails._MonthlyReportData;
for (int i = 0; i < saleDateList.Count; i++)
{
DataRow drow = dataTable.NewRow();
string[] fDate = Regex.Split(fromDate.ToString(), " ");
drow["DateFrom"] = fDate[0];
string[] tDate = Regex.Split(toDate.ToString(), " ");
drow["DateTo"] = tDate[0];
drow["BillNoFrom"] = bnoFromList[i];
drow["BillNoTo"] = bnoToList[i];
drow["SaleDate"] = saleDateList[i];
drow["GrossValue"] = totalPriceList[i];
drow["Discount"] = discountList[i];
drow["Gst"] = netGstList[i];
drow["SalesReturn"] = salesReturnList[i];
drow["Credit"] = creditList[i];
drow["CashPaid"] = cashPaidList[i];
drow["GrandTotal"] = grandTotalList[i];
drow["TotalExpense"] = expenseAmountList.Sum();
dataTable.Rows.Add(drow);
}
DataRow droww = dataTable.NewRow();
droww["TotalGross"] = totalPriceList.Sum();
droww["TotalDiscount"] = discountList.Sum();
droww["TotalGst"] = netGstList.Sum();
droww["TotalSalesReturn"] = salesReturnList.Sum();
droww["TotalCredit"] = creditList.Sum();
droww["TotalCashPaid"] = cashPaidList.Sum();
droww["TotalGrand"] = grandTotalList.Sum();
droww["NetExpense"] = expenseAmountList.Sum();
dataTable.Rows.Add(droww);
Report.Database.Tables["MonthlyReportData"].SetDataSource((DataTable)dataTable);
sales_Reporter_Viewer.ViewerCore.ReportSource = Report;
Report.Refresh();
}
