Create a job status report

  2. Click Status Reports in the CCLAS EL menu or run the StatRep.exe application in the Exe folder to display the StatRep Form.

  3. To define the report template, target output, print requirements, and filter by job origin, analysis focus, or job:

    1. Select the General tab.
    2. Select the Report template, and enter the Output file.
    3. Specify the View mode.
    4. Check Print and select the Printer and No. of copies to have the generated report documented printed.
    5. To filter jobs by origin, select either Client, Client group or Costcentre:
      1. Where Client is selected, then enter a search string in the field that matches one or more client codes, using the percent sign (%) as a wildcard, and click the F2 function key to open the client lookup form to display matching client codes from all laboratories, including clients that are disabled. Double-click the required client code.
      2. Where Client group code is selected, then select one or more client groups using the Ctrl and Shift keys.
      3. Where Costcentre is selected, select one or more cost centres using the Ctrl and Shift keys.
    6. To filter schemes by analysis focus, then select either Section, Section group or Scheme:
      1. Where Section is selected, then select one or more sections using the Ctrl and Shift keys.
      2. Where Section group is selected, then select one or more section groups using the Ctrl and Shift keys.
      3. Where Scheme is selected, then select one or more schemes using the Ctrl and Shift keys.
    7. To filter jobs by job number, select either Discrete jobs or Job Range:
      1. Where Discrete jobs is selected, then select one or more jobs using the Ctrl and Shift keys.
      2. Where Job range is selected, then select the first job in the range, select the last job in the range.
    8. Where the Properties main menu option is enabled, to further filter the grid content based on column criteria, select the Properties main menu option and filter data using column criteria. Refer to Using the Screen Interface.
    9. Click Save.
  4. To filter by job dates or sample type, and apply sort criteria:
    1. Select the Misc tab.
    2. Click ... next to Received, Registered, Required, Started, Completed, Validated, First Reported and/or Last Reported to open the date range picker, enter the date window and click OK.
    3. Select one or more sample types from the Sample type list.
    4. To sort jobs by selected fields, select one or more job fields in the Sort by panel, using the up and down arrows to change the order within the sort.
  5. To reload the status report requirements, click Refresh.
  6. Click Report to generate the status report. If the report template is an XLS file, the report is created using Microsoft Excel™. If the report template is an RPT file, the report is created using Crystal Reports™.