Example custom report

This is an example of a custom report for tracking specimens on shipments that have not been sent.

This report will find all specimens in your laboratory’s database that are part of a shipment and are still available. It filters by specimens that are available and have a shipment setup date (all specimens with a shipment setup date will meet the “before 30/Sep/2099” criteria, since that date is in the future). This report would be useful for identifying specimens that you are expected to ship but still have in your possession.

Fields to display
  • Global specimen ID
  • Batch number
  • QA/QC status
  • Shipment setup date
  • Destination laboratory ID
Sort results by
  • Destination laboratory ID
  • Batch number
Selection criteria
  • Available = Yes
  • Destination laboratory ID <> Your_Laboratory_ID
  • Shipment setup date < 30/Sep/2099