private void informeDeVentasToolStripMenuItem_Click(object sender, EventArgs e)
{
SQLiteCommand consulta = con.DameComando();
consulta.CommandText = "SELECT * FROM Cliente";
SQLiteDataAdapter DataAdap = new SQLiteDataAdapter(consulta);
DataSet1 Ds = new DataSet1();
DataAdap.Fill(Ds, "Cliente");
consulta.CommandText = "SELECT * FROM Coche";
DataAdap.Fill(Ds, "Coche");
consulta.CommandText = "SELECT * FROM Venta";
DataAdap.Fill(Ds, "Venta");
if (Ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No hay datos que mostrar, revisar la SQL", "Informe");
return;
}
InformeVentas informe = new InformeVentas();
informe.Load("..\\..\\InformeVentas.rpt");
informe.SetDataSource(Ds);
ventana_informe.crystalReportViewer1.ReportSource = informe;
ventana_informe.crystalReportViewer1.Refresh();
ventana_informe.ShowDialog();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
InformeVentas rpt = new InformeVentas();
rpt.Site = this.Site;
return(rpt);
}
