There is a valid VB command "CountDistinct" I could use to count the distinct number of peaks within the injection. However, there is no equivalent command like "SumDistinct". This would have been a simple solution.
So, there are 2 solutions that should do the job:
- add 2 text fields next to each other
- enter the peak retention time in one of the fields and the peak area in the other. Save the peak_area in aggregator using the peak_ID as
- group both fields
- repeat the group on Peak_ID
- Add another text field outside and below of the group. Fill the field with the aggregator output.
- Use your table as defined in the template
- Define an aggregator on the peak_area column as described in solution 1
- add a text field below the table and fill the field with the aggregator output.
- For each column check the "hide duplicate values". This will generate empty white lines in the table print out. Table rows that contain duplicates in each column are not hidden by default. There is another post in this forum that described how to change the row properties to auto-hide the empty rows. It requires a manual modification of the RDL file with notepad.
Hello again Bernhard!
I was able to incorporate your Solution 1 into a prototype and pass it on to the user to make sure that it works OK for them (The key to everything was Peak_ID - I was stupidly using Compound_Name)
They would, of course, vastly prefer to be able to filter an peak table based on group_type <> "Named Peaks" but I am hopeful that this will work alright for them
Many thanks! - Lisa