Record Selection based on highest number

[Boman]

I have multiple records in a group. Each record has a unique sequence no. I need to pass the highest sequence no. using a shared var to my main rpt to perform a calc on the main rpt.
i.e.
invno seqno price date time
7601 1 $150 06/17/02 12:00
7601 2 $500 06/17/02 12:05
7601 3 $600 06/17/02 12:05
etc etc etc etc etc

I need the record with the highest seqno.

 

[synapsevampire]

You should be able to just use a maximum(seqno) to define the shared variable.

It sounds like you understand the shared variables portion so I'll forego describing that unless you state otherwise.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com