OLIR works different than EZChrom advanced reporting: All data is always there, so instead of adding a reference table and using lookup functions, you just need to filter the data.
So add a table from the snippets and filter it to the data you need. Or create a group and filter the group on what you need, so the table or values inside the group show the data you want.
To transfer results use the variables that are available when you have an expression (Use the "Save as variable" button in the expressions editor.
Hi Marc, i know how hand over values in a matrix or from one table to the other. What i mean is simply to have a predefined set of values in a table (or entity) and select the right info from there. This for instance in RGA calculations for BTU. Not sure if the report parameters functionality multi value can cover this easily! As these are compound parameters and not report parameters.
I am using report parameter multi value to store all compound value, use join expression to store all compound name and value.
Report parameter multiple value like as below
and use Join function to store as string that look likes A|1, B|2, C|3,......
use Choose and Split function to separate string to extract value based on compound name
if you have better idea, pls let me know. I attached data and template etc for reference.
2013-0627_new2.zip 593.1 KB
I think Qi Hong's idea is the simplest one for now.
With the next version of IR (for ChemStation/EZChrom , NOT OLIR) you can integrate a custom assembly (.NET DLL), which you could create using VB.NET. This would even allow you to read such information from an external text file.
Not as simple as the advanced report approach but the best you can do.
You might also be able to use custom fields (EE: custom parameters) with default values which you define in the CDS.
I went ahead and flagged the "Correct Answer" on this post. If you still need help though, please let us know and we would be happy to continue working with you.