Struggling with report builder for MassHunter Quant 10

Hi strob,

What is the exact version of quant you are using? Is it 10.0 or 10.1? There are some potential differences even just between those two revisions. 

What you want to do may be possible, but the bindings will not be trivial, as msweber mentions above. Part of the issue is trying to get two rows of the database table to print in one row of the report, if I'm understanding the issue correctly.

If you can share your template, or at least the bindings you have so far, it may be possible to come up with something that will work. 

Hi howard_sanford, thanks for replying.

I'm using Quant 10.1 and Report Builder 10.2.1. 

Yes that's where I realised I couldn't get any further, because of my data bindings each qualifier is going into its own line and I couldn't think of a way to alter the bindings. I'll try and attach the report template to the original question.

strob,

I apologize for the delay in responding. I didn't get notification of your edit so I only recently saw that you had updated the post with your template.

A colleague was able to modify your template to list the two qualifiers in each row, rather than having the rows repeat with two copies of the same qualifier on each. 

Hi howard_sanford, 

Thanks for your reply. 

I tried that template but got this error when I attempted to generate the report.

strob,

The error didn't come through, but I know that if any of your compounds have no qualifiers that template will generate an error. It will work for compounds with only one qualifier, but that qualifier will be displayed twice.

If that doesn't sound like what the issue is, please try using the template with some of the shipping data for a test. I know that the QQQ Drugs of Abuse data set will work with this template, but with duplicate qualifiers as I note above. 

strob,

The error didn't come through, but I know that if any of your compounds have no qualifiers that template will generate an error. It will work for compounds with only one qualifier, but that qualifier will be displayed twice.

If that doesn't sound like what the issue is, please try using the template with some of the shipping data for a test. I know that the QQQ Drugs of Abuse data set will work with this template, but with duplicate qualifiers as I note above. 

howard_sanford, 

It was the internal standards that were causing the problem as we don't have qualifiers for them.

An additional binding of <ISTDFlag>!=TRUE worked.

Thanks for your help with this, it's greatly appreciated.

Cheers

Steve