calculating total into a report

[vassilis]

hello...
does anybody know if i can calculate a grand total into a report which is
coming from calculated items ? or i need to store first all these values ?
thanks

 

[Marshall Barton]

does anybody know if i can calculate a grand total into a report which is
coming from calculated items ? or i need to store first all these values ?

Add a text box (named txtRunsomething) next to the
calculated text box. Set it's control source expression to
=calculatedtextbox and its RunningSum property to Over All.

The report footer text box can then display the grand total
by using the expression =txtRunsomething