Storing data to be printed later

[caymanuser]

I have a single dbase file where the first ten records contain performance data that is to be printed on each statement utilising data from Record 11 and onwards

Therefore every statement would show as below:
Total gain/loss - from record 1
Interest - from record 2
Total gain - from record 3
Etc. - from record 4 to
Etc. - from record 10

Inividual client performance data - record 11 onwards

Every record from the 11th onwards is a new statment.

What is the best way to store the data from the 1st ten records so it can be used with the 11th and subsequent records?

Thank you in advance.

 

[synapsevampire]

Create a formula to capture these:

whileprintingrecords;
global numbervar Total gain/loss;
global numbervar Interest;
global numbervar Total Gain;
//etc
if recordnumber = 1 then
Total gain/loss := {table.value};
if recourdnumber = 2 then
Interest := {table.value};
if recourdnumber = 3 then
Total gain := {table.value}
//etc.

Now you can reference these in any formula by using:

// Formula gain/loss
whileprintingrecords;
global numbervar Total gain/loss;
Total gain/loss

or you can use them in other formulas to do aggregates, etc.:
whileprintingrecords;
global numbervar Total gain/loss;
Total gain/loss/100

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com