static ReportsView()
        {
            dsReport = new dsReport();
            reportServiceTableAdapter daReportService = new reportServiceTableAdapter();
            reportSaleTableAdapter    daReportSale    = new reportSaleTableAdapter();

            try
            {
                daReportService.Fill(dsReport.reportService);
                daReportSale.Fill(dsReport.reportSale);
            }
            catch { }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            pnlReport.Visible = false;
            gvService.Visible = true;
            //this.txtEndDate.Text = DateTime.Today.ToShortDateString();
            if (User.Identity.IsAuthenticated)
            {
                pnlHide.Visible = true;
            }
            else
            {
                Response.Redirect("~/Login.aspx");
            }
            //refresh instances of services and sales on page refresh
            reportServiceTableAdapter daReportService = new reportServiceTableAdapter();
            reportSaleTableAdapter    daReportSale    = new reportSaleTableAdapter();

            try
            {
                daReportService.Fill(dsReport.reportService);
                daReportSale.Fill(dsReport.reportSale);
            }
            catch { }
        }