How can I get all my compounds being reported for all samples in a batch even if a compound was not detected or zeroed?
All reports (batch, not sample) I tried leave out those compounds but I need them for our LIMS-transfer.
Can I make those compounds appear in the report or will only positive hits be reported?
Hi Stemmerichk,
I've attached a copy of a PDF-ReportBuilder template which will generate a .CSV file suitable for a LIMS system. PDF-ReportBuilder is the preferred reporting engine for most customers because it has a very simple system for making edits - namely using the Report Builder tool which ships with Quant B.08 and greater. This template was designed for Quant 10. But the changes I've made can be applied just the same to B.08 and B.09.
The first change one needs to make is to apply a Left outer join to the 'TargetCompound' binding in the compound results table. This will let us generate results even if the compound is not found.
Next - we need to apply another Left outer join to the Qualifier data so we can get results even when the qualifier peak is not found:
Finally - we need to replace the value for the CalculatedConcentration with an expression that replaces the concentration field with ND when needed:
And here is the text of that expression:
import System
import clr
clr.AddReference("System.Drawing")
import System.Drawing
if BoundItems["TargetCompound"].IsCalibrationReferenceCompoundIDNull():
TemplateItems["Cell"].BackgroundColor = System.Drawing.Color.White
else:
TemplateItems["Cell"].BackgroundColor = System.Drawing.Color.LightGray
"ND" if BoundItems["TargetPeak"] is None or BoundItems["TargetPeak"].IsFinalConcentrationNull() else BoundItems["TargetPeak"].CalculatedConcentration
Hi Stemmerichk,
To filter out ISTDs - one would add an ISTDFlag != TRUE (or = FALSE) filter to the 'TargetCompound' binding. It would look like this:
I've attached an example with this modification to this thread.
