private void ShowReportButton_Click_1(object sender, EventArgs e)
 {
     string fromDate = dateTimePicker1.Value.ToString("yyyy-MM-dd");
     string toDate = dateTimePicker2.Value.ToString("yyyy-MM-dd");
     ReportGateway reportGateway=new ReportGateway();
     TotalReports totalReports=new TotalReports();
     List<TotalProductReport> aReport=reportGateway.GetInvoices(DateTime.Parse(fromDate), DateTime.Parse(toDate));
     totalReports.SetDataSource(aReport);
     crystalReportViewer1.ReportSource = totalReports;
 }
 public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
 {
     TotalReports rpt = new TotalReports();
     rpt.Site = this.Site;
     return rpt;
 }