Data binding quandary in Report Builder

I am editing the shipping template:  Gen_Complete_ISTD

I want to customize the top portion which is essentially a batch summary (see attached) to include the tune information and the field value of AcqOperator instead of AnalystName.  Our analysts don't have separate logins into the instrument computers, and I understand this is where field value AnalystName is populated from.  AcqOperator is where our analysts would be identified, Unfortunately, these are under the data binding "Sample" and not Batch or BatchAttribute.  

I added "Sample" to the data binding for this table and I ended up with multiple lines so that these items were listed for every single sample in the batch for this batch summary.  Obviously, I just want it once at the top of the page.

This is in comparison to further down the report template under the "Sample Report" portion.  I can select "Sample" data binding to include AcqOperator, yet the data binding for the table appears to be only "Batch," just like it is in the top portion!  "Sample" doesn't appear to be in the data binding of this table whatsoever, yet I am able to select it to get AcqOperator and it works how I need it to.  I've tried to replicate everything in the top portion to get the same result I get in this lower portion, but I just can't.  

How can I achieve this?

 

Parents
  • That was originally yellow highlight, but now it seems here it just yellow solid blocking what I wanted to be seen.  Here is with without the markups.

  •  Hello  ,

    Since the AcqOperator is stored for each sample, if you only want to pull one for the batch summay table you could use the <Top 1> filter on your Sample bind for the first table. Since this information is stored for each sample, it is possible to have a batch where there are different AcqOperators for each run. Depending on your lab procedures and workflows this may not be an issue, but it is something to be aware of in your report if those procedures ever change. 

    I believe you are able to access Sample in the Sample Report section because this is bound in the list List-Sample that the table BatchTable is a part of. 

  • Ah, not what I wanted to hear.  I think there could very well be situations where there are different AcqOperators if multiple runs were combined.  It's just too much of a risk to use <Top 1> filter for this, but I'm glad to learn of this application.  

    I ended up just taking TuneFileName, Tune Last Update, and AcqOperator off that BatchTable and moving them to the Sample Report. The whole thing will print, so all the information will be available for the batch and each sample.  Although, I really think it is most appropriate for Batch Data summary pages.  Maybe in the future these could also be associated with Batch Attributes?  Obviously AcqOperator needs to be identified for each sample, but tune information really may not need to be (at least in our application).

    Thanks for the info!

Reply
  • Ah, not what I wanted to hear.  I think there could very well be situations where there are different AcqOperators if multiple runs were combined.  It's just too much of a risk to use <Top 1> filter for this, but I'm glad to learn of this application.  

    I ended up just taking TuneFileName, Tune Last Update, and AcqOperator off that BatchTable and moving them to the Sample Report. The whole thing will print, so all the information will be available for the batch and each sample.  Although, I really think it is most appropriate for Batch Data summary pages.  Maybe in the future these could also be associated with Batch Attributes?  Obviously AcqOperator needs to be identified for each sample, but tune information really may not need to be (at least in our application).

    Thanks for the info!

Children
No Data
Was this helpful?