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();
}