Charlotte Foust
charlotte.foust at gmail.com
Wed Feb 13 17:34:38 CST 2013
Maybe I'm missing your point, but why would you want to show the grand total in the report header? Reports are band-generated, so the data hasn't been compiled yet at that point unless you create a special function to repeat all your calculations. That doesn't make sense to me. Charlotte On Wed, Feb 13, 2013 at 2:51 PM, David Emerson <newsgrps at dalyn.co.nz> wrote: > Team, > > I have a batch report which has a subreport of items in the batch and > amounts. On the footer of the main report is a Grand Total of the > subreport > items as well as a couple of batch amounts. This works fine. > > Here is the control source for the fields: > = srpOrderDetailPrice!txtTotalCost + > [txtBaseSetTotal]+[txtFolderLabourTotal] > > I would like to show the Grand Total on the report header as well. When I > put the formula in the report header section it only includes the first > subreport item amount plus the two batch amounts. > > It looks like a timing issue. How can I get the report header field to > equal the report footer field amount? > > Regards > > David Emerson > Dalyn Software Ltd > Wellington, New Zealand > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >