Need to extract highest value from database, based on some field value 1

[Cormoran60]

Hi all,

Using CR 10

First time posting here and I'd like some help to resolve this scenario:

The database I am reading lists multiple orders organized as below (Order #, Version #, Part #).

What I am trying to do is to generate a report that will only show the highest version of all unique orders.

What I get now from the report

Order # Version # Part #
2525 1 Chuck
2525 1 Tire
2525 1 Brake pad
2525 2 Chuck
2525 2 Tire
2525 2 Brake pad
2525 2 Wheel cover
2526 1 Sealed beam
2526 1 Chuck
2526 1 Brake Drum

What I want on the report

Order # Version # Part #
2525 2 Chuck
2525 2 Tire
2525 2 Brake pad
2525 2 Wheel cover
2526 1 Sealed beam
2526 1 Chuck
2526 1 Brake Drum

Thanks

Cormoran60

 

[lbass]

Insert a group on Order# (you can suppress the group header and footer if you like). Then go to report->selection formula->GROUP and enter:

{table.version} = maximum({table.version},{table.order#})

If you need to do calculations across orders, you should use running totals, as the non-group selected records are still IN the report, just not displayed, and thus contribute to the more usual summaries. Running totals will ignore the non-group-selected records.

-LB

 

[Cormoran60]

Thanks a lot LB, it works perfectly.

Cormoran60