public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { DailySalesReport rpt = new DailySalesReport(); rpt.Site = this.Site; return(rpt); }
private void dailyReport() { DailySalesData reportDetails = new DailySalesData(); DataTable dtTable = reportDetails.CompanyDetails; DailySalesReport Report = new DailySalesReport(); readCompanyDetails(); DataRow drr = dtTable.NewRow(); drr["CompanyName"] = companyName; drr["CompanyDetails"] = companyDetails; dtTable.Rows.Add(drr); Report.Database.Tables["CompanyDetails"].SetDataSource((DataTable)dtTable); addList(); DataTable dataTable = reportDetails.DailySaleData; 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]; string[] sDate = Regex.Split(saleDateList[i], " "); drow["SaleDate"] = sDate[0]; drow["GrossValue"] = totalPriceList[i]; drow["Discount"] = discountList[i]; drow["Gst"] = netGstList[i]; drow["SalesReturn"] = salesReturnList[i]; drow["GrandTotal"] = grandTotalList[i]; drow["Credit"] = creditList[i]; drow["CashPaid"] = cashPaidList[i]; 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["TotalGrand"] = grandTotalList.Sum(); droww["TotalCredit"] = creditList.Sum(); droww["TotalCashPaid"] = cashPaidList.Sum(); dataTable.Rows.Add(droww); Report.Database.Tables["DailySaleData"].SetDataSource((DataTable)dataTable); sales_Reporter_Viewer.ViewerCore.ReportSource = Report; Report.Refresh(); }