DMin Functionality

[Betz]

We have been using DMin function in Access Reports. Need same in Crystal version 9.5 - Is there a similiar function to this in Crystal?

 

[lupins46]

there are conditional aggregate functions
minimum(field, groupfield)
which might be applicable but it depends on what you want to do.

 

[synapsevampire]

You're probably going to be better served to post technical information rather than generic questions.

Database/connectivity used
Example data
Expected output

Crystal has a Running Total, which combined with the proper grouping within the report will allow you to use the evaluate->use a formula to select rows.

Or if this is intended to limit rows for the whole report, then use the Report->Edit Selection Formula-Group and place in the criteria there after you've included the appropriate group (which is the same as the second criteria in the dmin function).

-k

 

[Betz]

Thanks for the help lupins46 and synapsevampire - I just needed some direction and these posts did that. Actually simplier than I was thinking (I was going for an intense selection formula). The solution involved adding another group, and to that group adding the minimum function.

Thanks again.