public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { demographic rpt = new demographic(); rpt.Site = this.Site; return(rpt); }
private void demograhpicTrendToolStripMenuItem_Click(object sender, EventArgs e) { //create dataset trendchart //SELECT b.CustomerID, c.MemberCategory, b.BookedDate, b.BookedHour //FROM BookingTransaction AS b INNER JOIN //Customers AS c ON b.CustomerID = c.CustomerID //WHERE(b.Status IN //(SELECT Status // FROM BookingTransaction // WHERE(Status = 'confirmed'))) sf = new Sportsfacilities(); SportsfacilitiesTableAdapters.TrendchartTableAdapter ta = new SportsfacilitiesTableAdapters.TrendchartTableAdapter(); ta.Fill(sf.Trendchart); demographic cr = new demographic(); cr.SetDataSource(sf); crystalReportViewer1.ReportSource = cr; DisplayResults(); }