//populate report
        private void populateReportData(string HostID)
        {
            List <EventModel>   eventlist   = new List <EventModel>();
            List <StaffModel>   stafflist   = new List <StaffModel>();
            List <ProductInfo>  productlist = new List <ProductInfo>();
            ReportServiceClient report      = new ReportServiceClient();

            eventlist   = report.findEventbyID(HostID);
            stafflist   = report.findallstaffbyHostID(HostID);
            productlist = report.findallProductByHostID(HostID);
            if (eventlist == null && stafflist == null && productlist == null)
            {
                //Load new Reports
                ReportViewer1.LocalReport.DataSources.Clear();
                Response.Write("<script>alert('Report not found.');</script>");
            }
            else if (eventlist == null && stafflist == null && productlist != null)
            {
                //Load new Reports
                ReportViewer1.LocalReport.DataSources.Clear();
                ReportDataSource rd3 = new ReportDataSource("EventProduct", productlist);
                ReportViewer1.LocalReport.DataSources.Add(rd3);
                ReportViewer1.LocalReport.Refresh();
            }
            else if (eventlist == null && stafflist != null && productlist == null)
            {
                //Load new Reports
                ReportViewer1.LocalReport.DataSources.Clear();
                ReportDataSource rd2 = new ReportDataSource("EventStaff", stafflist);
                ReportViewer1.LocalReport.DataSources.Add(rd2);
                ReportViewer1.LocalReport.Refresh();
            }
            else if (eventlist != null && stafflist == null && productlist == null)
            {
                //Load new Reports
                ReportViewer1.LocalReport.DataSources.Clear();
                ReportDataSource rd1 = new ReportDataSource("HostEvents", eventlist);
                ReportViewer1.LocalReport.DataSources.Add(rd1);
                ReportViewer1.LocalReport.Refresh();
            }
            else if (eventlist != null && stafflist == null && productlist != null)
            {
                //Load new Reports
                ReportViewer1.LocalReport.DataSources.Clear();
                ReportDataSource rd1 = new ReportDataSource("HostEvents", eventlist);
                ReportDataSource rd3 = new ReportDataSource("EventProduct", productlist);
                ReportViewer1.LocalReport.DataSources.Add(rd1);
                ReportViewer1.LocalReport.DataSources.Add(rd3);
                ReportViewer1.LocalReport.Refresh();
            }
            else if (eventlist != null && stafflist != null && productlist == null)
            {
                //Load new Reports
                ReportViewer1.LocalReport.DataSources.Clear();
                ReportDataSource rd1 = new ReportDataSource("HostEvents", eventlist);
                ReportDataSource rd2 = new ReportDataSource("EventStaff", stafflist);
                ReportViewer1.LocalReport.DataSources.Add(rd1);
                ReportViewer1.LocalReport.DataSources.Add(rd2);
                ReportViewer1.LocalReport.Refresh();
            }
            else if (eventlist != null && stafflist != null && productlist != null)
            {
                //Load new Reports
                ReportViewer1.LocalReport.DataSources.Clear();
                ReportDataSource rd1 = new ReportDataSource("HostEvents", eventlist);
                ReportDataSource rd2 = new ReportDataSource("EventStaff", stafflist);
                ReportDataSource rd3 = new ReportDataSource("EventProduct", productlist);
                ReportViewer1.LocalReport.DataSources.Add(rd1);
                ReportViewer1.LocalReport.DataSources.Add(rd2);
                ReportViewer1.LocalReport.DataSources.Add(rd3);
                ReportViewer1.LocalReport.Refresh();
            }
        }