public frmSalesReportView(int month, string mon)
{
try
{
InitializeComponent();
int salesmonth = month;
con.Open();
SqlDataAdapter SDA = new SqlDataAdapter("select sum(amounttobepaid) from Orderbill where month(date)=" + salesmonth + "", 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 o.orderid ,c.customername,o.date,o.amounttobepaid,'" + mon + "' as month ," + amount + "as total from Orderbill o inner join Customer c on c.CustomerID=o.CustomerID where month(date)=" + salesmonth + "";
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds.DataTable3);
salesViewReport myr = new salesViewReport();
myr.SetDataSource(ds);
crystalReportViewer1.ReportSource = myr;
}catch (FormatException fex)
{
MessageBox.Show("No Sales on this month");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
salesViewReport rpt = new salesViewReport();
rpt.Site = this.Site;
return(rpt);
}