private void generateReport() { CustomerReportData reportDetails = new CustomerReportData(); CustomerReport report = new CustomerReport(); DataTable dataTable = reportDetails.CompanyDetails; readCompanyDetails(); DataRow drr = dataTable.NewRow(); drr["CompanyName"] = companyName; drr["CompanyDetails"] = companyDetails; dataTable.Rows.Add(drr); report.Database.Tables["CompanyDetails"].SetDataSource((DataTable)dataTable); DataTable daTable = reportDetails.CustomerReportTable; storeLists(); for (int i = 0; i < customerNameList.Count; i++) { DataRow drow = daTable.NewRow(); string[] custName = Regex.Split(customerNameList[i], " "); drow["CustomerName"] = custName[0]; drow["CustomerPhone"] = customerPhoneList[i]; drow["Credit"] = creditList[i]; daTable.Rows.Add(drow); } DataRow dr = daTable.NewRow(); dr["TotalCredit"] = creditList.Sum(); daTable.Rows.Add(dr); report.Database.Tables["CustomerReportTable"].SetDataSource((DataTable)daTable); customerReportViewer.ViewerCore.ReportSource = report; report.Refresh(); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CustomerReport rpt = new CustomerReport(); rpt.Site = this.Site; return(rpt); }