Struggling with report builder for MassHunter Quant 10

Hello strob,

I had this problem as well when I was trying to create a GCMS multicompound report. I found the issue stemmed from the data bindings. In instances where I had tried to combine "Sample" and "Compound" bindings, I needed to add in a filter to eliminate the overlapping results. I do recall having to do a lot of trial and error because I would change something and then cause an error and report would be mostly empty, or I would end up with duplicates of data and extremely long final report.

Here is an example:

The global data binding is for "Sample" and I wanted my table to have results from "Compound" and "SampleChromPeak". I added the following bindings for to the container and labeled the binding "SampleChromNoMod":

Data name: SampleChrom

Filters:

<Sample_Key>=<Sample:Sample_Key>

<Top 1>

My table had bindings for "Compound" and "SampleChromPeak"

Compound

Data name: Compound

Filters

<Sample_Key>=<Sample:Sample_Key>

AND <Sample_Key>=<SampleChrom:Sample_Key>

 

SampleChromPeak:

Data name: SampleChromPeak

Filters:

<Chrom_Key>=<SampleChrom:Chrom_Key>

AND <ReportSortOrder>=<Compound:ReportSortOrder>

For "Top 1" created filter for the key field (ex. Chrom_Key) with the "Top" operator and a fixed value of "1"

It took me a lot of trial and error a while ago, so unfortunately can't provide more exact information. I couldn't see any clear examples in the data bindings when I opened the template. 

There are a few people I was able to contact through tech support that work on Masshunter software and they were extremely helpful in trying to figure out what could be causing a given error. As you stated there isn't an actual instruction manual, but with a little programming knowledge and a lot of tinkering I was able to create a report that does everything I was looking to present.

Another place to look would be using the dropdown list on the right (above where you find data bindings) and change the settings in "GlobalReportProperties1"

Best of luck!

Hello strob,

I had this problem as well when I was trying to create a GCMS multicompound report. I found the issue stemmed from the data bindings. In instances where I had tried to combine "Sample" and "Compound" bindings, I needed to add in a filter to eliminate the overlapping results. I do recall having to do a lot of trial and error because I would change something and then cause an error and report would be mostly empty, or I would end up with duplicates of data and extremely long final report.

Here is an example:

The global data binding is for "Sample" and I wanted my table to have results from "Compound" and "SampleChromPeak". I added the following bindings for to the container and labeled the binding "SampleChromNoMod":

Data name: SampleChrom

Filters:

<Sample_Key>=<Sample:Sample_Key>

<Top 1>

My table had bindings for "Compound" and "SampleChromPeak"

Compound

Data name: Compound

Filters

<Sample_Key>=<Sample:Sample_Key>

AND <Sample_Key>=<SampleChrom:Sample_Key>

 

SampleChromPeak:

Data name: SampleChromPeak

Filters:

<Chrom_Key>=<SampleChrom:Chrom_Key>

AND <ReportSortOrder>=<Compound:ReportSortOrder>

For "Top 1" created filter for the key field (ex. Chrom_Key) with the "Top" operator and a fixed value of "1"

It took me a lot of trial and error a while ago, so unfortunately can't provide more exact information. I couldn't see any clear examples in the data bindings when I opened the template. 

There are a few people I was able to contact through tech support that work on Masshunter software and they were extremely helpful in trying to figure out what could be causing a given error. As you stated there isn't an actual instruction manual, but with a little programming knowledge and a lot of tinkering I was able to create a report that does everything I was looking to present.

Another place to look would be using the dropdown list on the right (above where you find data bindings) and change the settings in "GlobalReportProperties1"

Best of luck!

Hi msweber,

Thanks for your reply. Would you be open to sharing your report template so I could take a look at the bindings?

Cheers

Steve