use previous value of a shared NumberVar

[thebigbadwolf]

Can I somehow use previous value of a shared NumberVar which syntaxed

whileprintingrecords;
numbervar hours_line;
hours_line := hours_line + {VCR_EMPLOYEE_FEEDBACK.VWOEF_ACTUAL_HOURS};

?

 

[Madawc]

You'd need a separate statement to save it, e.g.

whileprintingrecords;
numbervar Prev_hours_line;
Prev_hours_line := hours_line

But it all depends where you put this command.

Consider also some other method, e.g. running totals that use a formula to collect for just some records. Or possibly crosstabs.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP