Intelligent report with varying injection sample name


I'm trying to create a intelligent report.
We use stock A and stock B as check for system suitability, but the report should also accept Standard solution F or Reference solution D.
Can you please help me with extracting the Sample_name when using the specific injection_label?
It's not possible by creating and saving an aggregate formula, as the whole report is created using intelligent reporting, but i'm not that familiar with custom calculation.

Thank you for your help!

  • Do you want a custom calculation to return the Sample_Name for a specific Injection_Label?

    Scope for this calculation has to be Sequence

    CurrentSequence.AllInjections.Where(function(item) item.Injection_SampleLabel Like "Your_Label").First().Sample.Sample_Name

    You could do this in a report using a table that is hidden:

    Start with a compound summary table, apply a filter

    Injection_Label LIKE "Your Label" = =true

    Save the Sample_Name column value as a variable

    Does that sound like it would work for you?

  • Hello,

    You cannot store anything but numbers as variables in IR. I would suggest using sample type as the filter for your system suitability injection instead of sample name if possible. 

    Marty Adams

Was this helpful?