• State Not Answered
  • Replies 3 replies
  • Subscribers 116 subscribers
  • Views 189 views
  • Users 0 members are here
Related

Agilent Knowledge Portal

Find maintenance, best practice, and troubleshooting articles.

Agilent Knowledge Portal

OpenLab CDS Reporting - MultiPeak Hit Table sort by RT

tblack

I'm trying to build a report for unknown samples with the following information below the TIC:

RT, MS Library Search Compound Name, Area, %Area, Library Name, Score

I am unable to figure out a way to display the MS Library Search Result Compound Name in the same table as the other desired information. The processing method does not have set compounds due to the nature of the unknown samples.

There is a MultiPeak Hit Table, which does not have Area as an option, but it has RT - So is there a way to sort this table by RT? Current default values are Score, Library Name, and Probability % 

Parents
  • 0

    Hello,

    I am not sure it gets you what you want but it is possible to sort that table on RT. See below for an example. It cannot be done within the software you would need to edit the raw RDL file in a text editor like notepad++. The sort order is below for the table in question. Please make sure you have a good copy of your report template in case you make a mistake editing it outside the software. 

    Sorting on Score

    CustomProperty>
    <Name>AgtSpectraLibrarySearchResults:SortInformation</Name>
    <Value>CustomSortingColumn_Score##Score##Descending##Int;</Value>
    </CustomProperty>

    Changed to 

    <CustomProperty>
    <Name>AgtSpectraLibrarySearchResults:SortInformation</Name>
    <Value>CustomSortingColumn_RT##RT##Descending##Int;</Value>
    </CustomProperty>

    Sort-RT

    Sort - Score

Reply
  • 0

    Hello,

    I am not sure it gets you what you want but it is possible to sort that table on RT. See below for an example. It cannot be done within the software you would need to edit the raw RDL file in a text editor like notepad++. The sort order is below for the table in question. Please make sure you have a good copy of your report template in case you make a mistake editing it outside the software. 

    Sorting on Score

    CustomProperty>
    <Name>AgtSpectraLibrarySearchResults:SortInformation</Name>
    <Value>CustomSortingColumn_Score##Score##Descending##Int;</Value>
    </CustomProperty>

    Changed to 

    <CustomProperty>
    <Name>AgtSpectraLibrarySearchResults:SortInformation</Name>
    <Value>CustomSortingColumn_RT##RT##Descending##Int;</Value>
    </CustomProperty>

    Sort-RT

    Sort - Score

Children
Was this helpful?
Privacy Statement
Terms of Use
Contact Us
Site Help