Holding 6 previous record values

[ComputerNurse]

I am writing a crystal report in which I will need to hold 6 previous weight values & the dates associated with the weights so that I can peform calculations. The weights are not always present. Can someone give an idea how to do this.
For example

1/1/2002- 120.1
1/7/2002- 121.4
1/22/2002-127.4
1/25/2003-128.8
1/29/2003-126.3
1/7/2004 -130.1

I need to be able to divide the 130.1 by the 127.4 to calculate a 3 month weight variance

 

[GJParker]

ComputerNurse

Your not really giving us enough information here.

How is your report set out i.e. does it contain groups ?

do woyu want the last 6 once per report or per group (if there is any grouping ?

What do you mean by

The weights are not always present

does this mean there are no records in the database or there is a date in the database and the weight filed is zero or null.

also include the Version of CR you are using and databasde you are reporting from.



Gary Parker
Systems Support Analyst
Manchester, England

 

[ComputerNurse]

The report is grouped on Patient ID, I want the last 6 for each group. A person may not have 6 previous weights, this could occur if they are newly added patient.

I am report off of a SQL enterprise database. I am using Crystal reports version 8.5.