Minimum returned value

[straud13]

I have a report that returns notes in the details section.
But only the notes that are type 9 and have the text 'escalated' in the note. This works.

Sometimes more than one note is returned to the report per group. In this case I want to select the note in that group that has the lowest sequence number. I will be performing aggregate calculations on this data so (from what I know) suppression will not work because the aggregate calc will total the suppressed records as well.

So how do I do this?

 

[synapsevampire]

Suppression could work, but it's a pain.

Consider posting technical information when posting:

Crystal version
Database
example data
expected output

This should work:

Report->Edit Selection Formula->Group

{table.note} = minimum({table.note},{table.groupfield})

Replacing the field names with your table field names.

-k

 

[straud13]

Your a star. Would you mind explaining how that formula works?