Hello,
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?
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?
