Filtering details within a group per group change

[mrainv]

Hey folks,

I have been working with CR10 for a while, mostly teaching myself as I go along. I have an issue I'm trying to resolve and it seems like there should be a solution but so far I have been unable to find it. This data comes from an Access output database.

Let me try and explain what I'm doing. Basically, it's fairly straightforward report that contains 3 groups. To give a bit of background, this report is being used to display information regarding quality control samples in a laboratory. I have a record selection which is already filtering for all the "replicate samples" in a batch of lab samples. What I am getting now is all the records for these replicates - {QCData.labnumber}. There are multiple values coming in per the parameter being analyzed. This happens within each analysis type;{QCData.analysisdescription} (this is also group 3)

It looks something like this:

Group 1 - Sample Type
Group 2 - Analysis Method
Group 3 - Analysis

{QCData.parameter} {QCData.labnumber} (there are several fields of data after this)

Details section - Parameter A 12345-REP1
Parameter A 12345-REP2
Parameter A 12345-REP3
Parameter B 12345-REP1
Parameter B 12345-REP2
Parameter B 12345-REP3
Parameter C 12345-REP1
Parameter C 12345-REP1
Parameter C 12345-REP1

What I would like to happen is on every new analysis (ie every change of group 3) one "replicate" to come in for every parameter in that analysis. So regardless of how many "replicate" records there are, I only want the first one per parameter.

It could be 12345-REP1, REP2, REP3 etc...and so on. But another factor here is that every analysis could contain 1 or several parameters to which that replicate would apply. So ideally the above example would look like:

Parameter A 12345-REP1
Parameter B 12345-REP1
Parameter C 12345-REP1

I am hoping there is some kind of filtering formula that would apply to this situation.

I hope this makes sense and I apologize if it's a bit confusing.

Thanks in advance.

 

[mintman]

Why dont you insert a Summary on that(MAX).I guess it should work

 

[mrainv]

Thanks for the reply.

I'm a little unclear though, I'm assuming you are talking about a summary of the {QCData.labnumber} field which would always give the highest value. This would work as I only need one "replicate" regardless of which one it is. However, where exactly would I insert this summary? I guess I forgot to mention that when all is said and done I don't want the {QCData.labnumber} to actually display in the report.

Thanks,

 

[Madawc]

If you group by parameter, you can show the standard fields in the group header and suppress the detail lines.

If you sorted the group by {QCData.labnumber}, the first detail line should have the lowest value, and that would be the value that the group header would show.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10