private void frmOccupancyReport_Load(object sender, EventArgs e) { DataSet6 ds = new DataSet6(); DataSet6TableAdapters.bookinginvoicereportTableAdapter da = new DataSet6TableAdapters.bookinginvoicereportTableAdapter(); da.Fill(ds.bookinginvoicereport); Occupancy cr = new Occupancy(); cr.SetDataSource(ds); cr.SetParameterValue("dateFrom", ucReports.datefrom); cr.SetParameterValue("dateTo", ucReports.dateto); crOccupancy.ReportSource = cr; }
private void Form2_Load(object sender, EventArgs e) { SportsFacilitiesEntities ctx = new SportsFacilitiesEntities(); // Members Listing //DataSet1 ds = new DataSet1(); //DataSet1TableAdapters.MembersTableAdapter da = new DataSet1TableAdapters.MembersTableAdapter(); //da.Fill(ds.Members); //MemberListing cr = new MemberListing(); //cr.SetDataSource(ds); //crystalReportViewer1.ReportSource = cr; // Booking Invoice //DataSet2 ds = new DataSet2(); //DataSet2TableAdapters.bookinginvoicereportTableAdapter da = new DataSet2TableAdapters.bookinginvoicereportTableAdapter(); //da.Fill(ds.bookinginvoicereport); //BookingInvoice cr = new BookingInvoice(); //cr.SetDataSource(ds); //crystalReportViewer1.ReportSource = cr; // Membership Form //DataSet3 ds = new DataSet3(); //DataSet3TableAdapters.MembersTableAdapter da = new DataSet3TableAdapters.MembersTableAdapter(); //da.Fill(ds.Members); //MemberForm cr = new MemberForm(); //cr.SetDataSource(ds); //crystalReportViewer1.ReportSource = cr; // Monthly Revenue Report //DataSet4 ds = new DataSet4(); //DataSet4TableAdapters.revenuereportTableAdapter da = new DataSet4TableAdapters.revenuereportTableAdapter(); //da.Fill(ds.revenuereport); //MonthlyRevenue cr = new MonthlyRevenue(); //cr.SetDataSource(ds); //crystalReportViewer1.ReportSource = cr; // March Revenue Report //DataSet5 ds = new DataSet5(); //DataSet5TableAdapters.revenuereportTableAdapter da = new DataSet5TableAdapters.revenuereportTableAdapter(); //da.Fill(ds.revenuereport); //MarchRevenue cr = new MarchRevenue(); //cr.SetDataSource(ds); //crystalReportViewer1.ReportSource = cr; //Occupancy Report //DataSet6 ds = new DataSet6(); //DataSet6TableAdapters.bookinginvoicereportTableAdapter da = new DataSet6TableAdapters.bookinginvoicereportTableAdapter(); //da.Fill(ds.bookinginvoicereport); //Occupancy cr = new Occupancy(); //cr.SetDataSource(ds); //crystalReportViewer1.ReportSource = cr; //Booking Availability Report DataSet6 ds = new DataSet6(); DataSet6TableAdapters.bookinginvoicereportTableAdapter da = new DataSet6TableAdapters.bookinginvoicereportTableAdapter(); da.Fill(ds.bookinginvoicereport); BookingAvailability cr = new BookingAvailability(); cr.SetDataSource(ds); crystalReportViewer1.ReportSource = cr; }