Back to Home

48 Hour Report

Table of Contents

Overview

The 48 Hour Report tracks Intake Forms that remain open over 48 hours and can be filtered and displayed by drop down lists. To view all outstanding intake forms, check the checkbox labeled "Show all outstanding" (Shows all intake forms that are currently active regardless if it's been opened longer then 48 hours)

  1. Show All Months
  2. Select Audit Stage
  3. Select QR Team
  4. Select Sample Class
  5. Select checkbox "Show all outstanding"
  6. Send Email Button

Capture.PNG

"Send Email" button is only visible when it is in Audit StageNo 4 - BO Review. Otherwise it is hidden. See code image and code for codebehind p11_Report_48Hours.aspx.cs

Capture.PNG

    protected void dgv_Primary_DataBound(object sender, EventArgs e)
    {
        GridView gv = dgv_Primary;

        pnl_Excel_48Hour.Visible = gv.Rows.Count > 0;

        foreach (GridViewRow row in gv.Rows)
        {
            if (row.Cells[0].Text != "4")
                (row.FindControl("btn_Email") as Button).Visible = false;
        }
    }

Table and Column Used

Smart.p11_intakeform (DateSubmitted)

column is used to determine which intake forms have been open for over 48 hours. Weekends are excluded from the calculation. 48 Hour Report

Stored Procedure

Smart.p11_Report_48Hour