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();
}
public static void ReportData(string date1, string date2, string custname)
{
try
{
SqlCommand cmd = new SqlCommand("select c.PriceGroup,a.SOPTYPE,a.SOPNUMBE,a.ITEMNMBR, a.ITEMDESC, a.XTNDPRCE," +
"a.QUANTITY, b.DOCDATE, b.CUSTNAME from SOP30300 a, SOP30200 b,IV00101 c where a.SOPNUMBE = " +
"b.SOPNUMBE and a.ITEMNMBR = c.ITEMNMBR and b.DOCDATE >= \'" + date1 + "\'" +
"and b.DOCDATE <= \'" + date2 + "\' and b.CUSTNAME = '" + custname +"' order by SOPNUMBE", connection);
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
while (reader.Read())
{
ReportContainerClass rc = new ReportContainerClass();
rc.pricegroup = reader["PriceGroup"].ToString().Trim();
rc.soptype = Convert.ToInt32(reader["SOPTYPE"]);
rc.custname = reader["CUSTNAME"].ToString().Trim();
rc.docdate = Convert.ToDateTime(reader["DOCDATE"].ToString());
rc.itemDescription = reader["ITEMDESC"].ToString().Trim();
rc.itemnumber = reader["ITEMNMBR"].ToString();
rc.price = Convert.ToDecimal(reader["XTNDPRCE"].ToString());
rc.quantity = Convert.ToInt32(reader["QUANTITY"]);
rc.sopnumber = Convert.ToString(reader["SOPNUMBE"].ToString().Trim());
reportlist.Add(rc);
}
reader.Close();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
