Trouble with PDF Report Builder method - DBNull.

Hello mkcrisp2,

Report Builder expressions do not automatically handle missing values or null database entries. You must check for these yourself. Most values have a IsValueNameNull() method that returns a boolean that can be used to check for no entry. There are examples in the shipping templates, such as this expression from the Gen_ResultsSummary_ISTD report template.

"ND" if BoundItems["TargetPeak"] is None or BoundItems["TargetPeak"].IsFinalConcentrationNull() else BoundItems["TargetPeak"].FinalConcentration

This will either report the FinalConcentration or if no target peaks are found or there is no value calculated for the FinalConcentration then it will report 'ND' (Not Detected) for the result.

Hello mkcrisp2,

Report Builder expressions do not automatically handle missing values or null database entries. You must check for these yourself. Most values have a IsValueNameNull() method that returns a boolean that can be used to check for no entry. There are examples in the shipping templates, such as this expression from the Gen_ResultsSummary_ISTD report template.

"ND" if BoundItems["TargetPeak"] is None or BoundItems["TargetPeak"].IsFinalConcentrationNull() else BoundItems["TargetPeak"].FinalConcentration

This will either report the FinalConcentration or if no target peaks are found or there is no value calculated for the FinalConcentration then it will report 'ND' (Not Detected) for the result.