Skip to Content
0
Former Member
Nov 28, 2009 at 12:06 PM

First an last record

290 Views

Hello

Im am searching a way to get the value of the first and last record from a table, by a crystal reports 2008 formula. It cannot be using SQL or parameter.

The structure of the table is very simple:

Product: string

decription: string

price: money

date: date

I need to make calculation about profit and things like those, that are obtained by last(price) - first(price).

Lets imagine for this example that I only have one product with several prices and several dates. I can make the rest by myself.

But it seems that there are not those functions.

Any help?

Thanks in advance.