opening balance

[7007]

with parrameters selecting a certain period, for stock to apear. how do I create an opening balance for stock?
what formula should be used?

 

[pgtek]

hi
can u give more detail on what you want to do.
what version of crystal
formula, database table field etc.
this would help alot

cheers

pgtek

 

[MColeman]

I'm not quite sure what you're asking, but I hope this will
help point you in the right direction.

You can create a beginning balance for a formula in the group header.

whileprintingrecords;
shared currencyvar openbal;
openbal := {databasetable.fieldname1}

Then print the begin balance in the group header.
whileprintingrecords;
shared currencyvar openbal;
openbal

Then add to it in the detail.

whileprintingrecords;
shared currencyvar totalbal;
shared currencyvar openbal;
totalbal := openbal + {databasetable.fieldname2}

Then print the end balance in the footer.

whileprintingrecords;
shared currencyvar totalbal;
totalbal

Then reset the end balance after you print it.
whileprintingrecords;
shared currencyvar totalbal := 0