public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
sfbkreport rpt = new sfbkreport();
rpt.Site = this.Site;
return(rpt);
}
private void bookingToolStripMenuItem_Click(object sender, EventArgs e)
{
//create dataset reportbooktxn
//SELECT b.VenueID, b.BookedDate, b.BookedHour, b.CustomerID, b.Status, v.VenueName
// FROM BookingTransaction AS b INNER JOIN
// Venue AS v ON b.VenueID = v.VenueID
//WHERE(b.Status IN
// (SELECT Status
// FROM BookingTransaction
// WHERE(Status = 'confirmed')))
sf = new Sportsfacilities();
SportsfacilitiesTableAdapters.ReportbookingtxnTableAdapter ta = new SportsfacilitiesTableAdapters.ReportbookingtxnTableAdapter();
ta.Fill(sf.Reportbookingtxn);
sfbkreport cr = new sfbkreport();
cr.SetDataSource(sf);
crystalReportViewer1.ReportSource = cr;
DisplayResults();
}