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