Skip to Content

Get The Minium Value in Crystal Reports

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 14, 2018 at 05:08 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 18, 2018 at 07:35 PM

    Sorry for the delay!

    Thank u very much!

    Add comment
    10|10000 characters needed characters exceeded