Get The Minium Value in Crystal Reports

[Former Member]

I'm trying to use the Running Totals in Crystal Reports 8.5 to get the minimum value of a series of fields.

Ex.:

A - 50

B - 300

C - 400

I need to get the B - 300 line.

Is there anyother way to figure this is out without using the Running Totals?

Thanks in advance

[DellSC · Accepted solution]

Is your data grouped? If so, or if you want to do the minimum for the whole report, you can use the min summary function. If your data is grouped, you'll create a formula that looks like this:

min({field}, {group field})

If you need it for the whole report, the formula will look like this:

min({field})

-Dell

p.s. Crystal 8.5 has been out of support for over 10 years. As you upgrade your OS, it may not work with newer versions of Windows.

[Former Member]

Sorry for the delay!

Thank u very much!