MassHunter reports, grouping omitting some compounds

Hi Rob,

So just to clarify a few things, what revision of Quant are you using? And from the tags it looks like you are trying to use a Report Builder template, correct?

When you say you are using groups, are you utilizing compound groups and compound math to create aggregate compounds for Group 1 and 2? 

I am using Quant v. 10.01, Build 10.1.733.0
Yes, I am trying to use a Report Builder template. I am utilizing the compound groups and compound math to create aggregate compounds.

Actually, I used an attachment that you replied to in another post: 
https://community.agilent.com/technical/mass-spectrometry-software/f/mass-spectrometry-software-user-forum/1546/compound-group-function-in-masshunter/1904#1904

Rob,

I have found at least one way to do this. In my limited testing it appears to work. It is not very elegant, but it is simple to implement. Or at least for my data and report it was.

What you can do is utilize the User Defined and User Defined 1 fields.

Go into the method editor and put an entry in the User Defined column for every compound that you do NOT want reported.

Then in the User Defined 1 column make an entry that will sort alphabetically in the order you want the compounds to appear in. Since I had less than 26 I just used a,b,c.

You can add these columns in the main Compound setup window and it will look something like this.

Now in the bindings for your report where you filter for the target compounds, add a filter for <UserDefined> is NULL. 

Then change the sorting to be done by UserDefined1. It should look something like this.

In my modified template it resulted in this output. 

Rob,

I have found at least one way to do this. In my limited testing it appears to work. It is not very elegant, but it is simple to implement. Or at least for my data and report it was.

What you can do is utilize the User Defined and User Defined 1 fields.

Go into the method editor and put an entry in the User Defined column for every compound that you do NOT want reported.

Then in the User Defined 1 column make an entry that will sort alphabetically in the order you want the compounds to appear in. Since I had less than 26 I just used a,b,c.

You can add these columns in the main Compound setup window and it will look something like this.

Now in the bindings for your report where you filter for the target compounds, add a filter for <UserDefined> is NULL. 

Then change the sorting to be done by UserDefined1. It should look something like this.

In my modified template it resulted in this output. 

Hi Howard,

Thank you for taking the time to give such an extensive answer. It looks like a pretty good workaround, I will try implementing this into my reports.

Thanks so much!

Rob

Hi Howard, Can you do this for the compound graphics on the same report are well? 

Hello Chalbrecht,

Yes, the same filters and sorting should work on the bindings for the compound graphics list.

Hi Howard, I am struggling with the data bindings for the graphics. I have a User defined  field assigned, but when I assign selected compound, userdefined, not null, I am getting multiple pages of repeating graphics that are not sorted (includes all compoounds).  My results table is working with the filter. Is there different bindings or multiple bindings that need to be done to achieve the same outcome for the graphic? 

Chalbrecht,

Starting from the default Gen_Samples_ISTD template, if I change the bindings for the Compound Chromatograms list, which is List2, to the following

Then it works as expected. It does include ISTDs as well, but you could remove those if you like. 

If you have made multiple changes from the base template you may need to back track to find where the issue is coming from.