private void LoadCrystalReport() { ReportView rv = new ReportView(); ReportSet ds = new ReportSet(); foreach (ReportContainerClass rc in GPData.reportlist) { if (rc.soptype == 4) { valuecontainer = (rc.quantity - (rc.quantity * 2)); valuecontainer2 = (rc.price - (rc.price * 2)); } else { valuecontainer = rc.quantity; valuecontainer2 = rc.price; } DataRow cRow = ds.ReportViewer.NewRow(); cRow["SOPNUMBER"] = rc.sopnumber; cRow["ITEMNUMBER"] = rc.itemnumber; cRow["CUSTOMERNAME"] = rc.custname; cRow["QUANTITY"] = valuecontainer; cRow["PRICE"] = valuecontainer2; ds.ReportViewer.Rows.Add(cRow); } ReportContainerClass rc1 = new ReportContainerClass(); rv.DataDefinition.FormulaFields["startDate"].Text = "\"" + Date.date1 + "\""; rv.DataDefinition.FormulaFields["End Date"].Text = "\"" + Date.date2 + "\""; rv.DataDefinition.FormulaFields["Customer"].Text = "\"" + customer + "\""; rv.SetDataSource(ds); crystalReportViewer1.ReportSource = rv; crystalReportViewer1.Refresh(); }
private void LoadCrystalReport() { ReportView rv = new ReportView(); ReportSet ds = new ReportSet(); foreach (ReportContainerClass rc in GPData.reportlist) { if (rc.soptype == 4) { valuecontainer = (rc.quantity - (rc.quantity * 2)); valuecontainer2 = (rc.price - (rc.price * 2)); } else { valuecontainer = rc.quantity; valuecontainer2 = rc.price; } DataRow cRow = ds.ReportViewer.NewRow(); cRow["SOPNUMBER"] = rc.sopnumber; cRow["ITEMNUMBER"] = rc.itemnumber; cRow["CUSTOMERNAME"] = rc.custname; cRow["QUANTITY"] = valuecontainer; cRow["PRICE"] = valuecontainer2; ds.ReportViewer.Rows.Add(cRow); } ReportContainerClass rc1 = new ReportContainerClass(); rv.DataDefinition.FormulaFields["startDate"].Text = "\"" + Date.date1 + "\""; rv.DataDefinition.FormulaFields["End Date"].Text = "\"" + Date.date2 + "\""; rv.DataDefinition.FormulaFields["Customer"].Text = "\"" + customer + "\""; rv.SetDataSource(ds); crystalReportViewer1.ReportSource = rv; crystalReportViewer1.Refresh(); }
private void PriceGroupReportViewer_Load(object sender, EventArgs e) { PriceGroup rv = new PriceGroup(); ReportSet ds = new ReportSet(); foreach (ReportContainerClass rc in GPData.reportlist) { if (rc.pricegroup == "") { PGroupChecker = "No PriceGroup Items"; } else { PGroupChecker = rc.pricegroup; } if (rc.soptype == 4) { valuecontainer = (rc.quantity - (rc.quantity * 2)); valuecontainer2 = (rc.price - (rc.price * 2)); } else { valuecontainer = rc.quantity; valuecontainer2 = rc.price; } DataRow cRow = ds.ReportViewer.NewRow(); cRow["PRICEGROUP"] = PGroupChecker; cRow["QUANTITY"] = valuecontainer; cRow["PRICE"] = valuecontainer2; ds.ReportViewer.Rows.Add(cRow); } rv.DataDefinition.FormulaFields["startDate"].Text = "\"" + Date.date1 + "\""; rv.DataDefinition.FormulaFields["End Date"].Text = "\"" + Date.date2 + "\""; rv.DataDefinition.FormulaFields["Customer"].Text = "\"" + customer + "\""; rv.SetDataSource(ds); crystalReportViewer1.ReportSource = rv; crystalReportViewer1.Refresh(); }
private void PriceGroupReportViewer_Load(object sender, EventArgs e) { PriceGroup rv = new PriceGroup(); ReportSet ds = new ReportSet(); foreach (ReportContainerClass rc in GPData.reportlist) { if (rc.pricegroup == "") { PGroupChecker = "No PriceGroup Items"; } else { PGroupChecker = rc.pricegroup; } if (rc.soptype == 4) { valuecontainer = (rc.quantity - (rc.quantity * 2)); valuecontainer2 = (rc.price - (rc.price * 2)); } else { valuecontainer = rc.quantity; valuecontainer2 = rc.price; } DataRow cRow = ds.ReportViewer.NewRow(); cRow["PRICEGROUP"] = PGroupChecker; cRow["QUANTITY"] = valuecontainer; cRow["PRICE"] = valuecontainer2; ds.ReportViewer.Rows.Add(cRow); } rv.DataDefinition.FormulaFields["startDate"].Text = "\"" + Date.date1 + "\""; rv.DataDefinition.FormulaFields["End Date"].Text = "\"" + Date.date2 + "\""; rv.DataDefinition.FormulaFields["Customer"].Text = "\"" + customer + "\""; rv.SetDataSource(ds); crystalReportViewer1.ReportSource = rv; crystalReportViewer1.Refresh(); }