public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport1 rpt = new CrystalReport1();
rpt.Site = this.Site;
return(rpt);
}
private void DetaliiFactura_Load(object sender, EventArgs e)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Open();
ParfumerieDataSet ds = new ParfumerieDataSet();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from Clienti where id_client=" + j + "";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds.DataTable1);
SqlCommand cmd1 = conn.CreateCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select * from ProduseCumparate where id_cump=" + j + "";
cmd1.ExecuteNonQuery();
DataTable dt2 = new DataTable();
SqlDataAdapter da2 = new SqlDataAdapter(cmd1);
da2.Fill(ds.DataTable2);
da2.Fill(dt2);
tot = 0;
foreach (DataRow dr2 in dt2.Rows)
{
tot = tot + Convert.ToInt32(dr2["total"].ToString());
}
CrystalReport1 rap = new CrystalReport1();
rap.SetDataSource(ds);
rap.SetParameterValue("total", tot.ToString());
crystalReportViewer1.ReportSource = rap;
}
