public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            LaporanFasilitas rpt = new LaporanFasilitas();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void btnTampil_Click(object sender, EventArgs e)
        {
            LaporanFasilitas rprtFasilitas = new LaporanFasilitas();

            try
            {
                rprtFasilitas.SetDatabaseLogon("probis", "probis");
            }
            catch (Exception)
            {
                throw;
            }
            OracleCommand query = new OracleCommand();

            query.Connection = conn;
            OracleDataAdapter adapter = new OracleDataAdapter(query);
            DataSet           dataset = new DataSet();

            query.CommandText = "SELECT * FROM CUSTOMER";
            adapter.Fill(dataset, "CUSTOMER");
            query.CommandText = "SELECT * FROM DHOTEL";
            adapter.Fill(dataset, "DHOTEL");
            query.CommandText = "SELECT DISTINCT replace(dkendaraan,'BIS',null)as DKENDARAAN,replace(dhotel_nama,'DALAM PERJALANAN',null) as DHOTEL_NAMA FROM DPAKET where tour_id='" + comboBox1.SelectedValue.ToString() + "'and dkendaraan != 'BIS' or dhotel_nama!='DALAM PERJALANAN order by 1' ";
            adapter.Fill(dataset, "DPAKET");
            query.CommandText = "SELECT * FROM DTRANS";
            adapter.Fill(dataset, "DTRANS");
            query.CommandText = "SELECT * FROM FLIGHT";
            adapter.Fill(dataset, "FLIGHT");
            query.CommandText = "SELECT * FROM HOTEL";
            adapter.Fill(dataset, "HOTEL");
            query.CommandText = "SELECT * FROM HTRANS; ";
            adapter.Fill(dataset, "HTRANS");
            query.CommandText = "SELECT * FROM MASKAPAI";
            adapter.Fill(dataset, "MASKAPAI");
            query.CommandText = "SELECT * FROM PAKET_TOUR";
            adapter.Fill(dataset, "PAKET_TOUR");
            query.CommandText = "SELECT * FROM PEGAWAI";
            adapter.Fill(dataset, "PEGAWAI");
            query.CommandText = "SELECT * FROM TRAINS";
            adapter.Fill(dataset, "TRAINS");
            rprtFasilitas.SetDataSource(dataset);
            //rprtTransaksi.SetParameterValue("tanggal_awal", dtAwal.Value);
            //rprtTransaksi.SetParameterValue("tanggal_akhir", dtAkhir.Value);
            crystalReportViewer1.ReportSource = rprtFasilitas;
        }