public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CustomerCreditReport rpt = new CustomerCreditReport();
rpt.Site = this.Site;
return(rpt);
}
public frmCustomerCreditViewReport()
{
InitializeComponent();
con.Open();
SqlDataAdapter SDA = new SqlDataAdapter("select sum(CreditValue) from customer", con);
DataTable dt = new DataTable();
SDA.Fill(dt);
float amount = float.Parse(dt.Rows[0][0].ToString());
DataSet1 ds = new DataSet1();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select customerid,customername,contactno,creditvalue," + amount + "as total from customer where creditvalue>0 ";
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds.DataTable4);
CustomerCreditReport myr = new CustomerCreditReport();
myr.SetDataSource(ds);
crystalReportViewer1.ReportSource = myr;
}
